Database Systems module (AC52001)

Data drives the modern world, with the amount of information in our databases growing exponentially each year. Whether you want to develop cutting-edge applications, extract valuable information from large datasets, or optimise business processes - a good understanding of database systems is key.

This module will allow you to develop expertise in the design and implementation of relational databases. The relational database model is one of the most prevalent database architectures in the industry.

You will further study Structured Query Language (SQL), which is used to interact with and modify the data in your databases.

What you will learn

In this module, you will:

• study the concepts of relational database models and their importance today
• learn how to design relational database solutions using ER diagrams
• learn about transaction management and how to write queries in SQL
• study how to evaluate a database solution
• investigate the concepts of data warehousing and data mining
• explore alternative database models
• investigate the legal, security, and professional issues relating to databases
• use these skills to design and implement your own database solution

By the end of this module, you will be able to:

• specify, design, and implement a professional database solution
• evaluate and address qualitative aspects of database solutions
• compare and contrast different database models
• show your understanding of legal, security, and professional issues relating to databases. This includes data protection legislation
• apply these skills to real-world scenarios

Assignments / assessment

• database design coursework (15%)
• database implementation coursework (35%)
• class tests (10%)
• formal exam (40%)

Teaching methods / timetable

You will learn by taking a hands-on approach. This will involve taking part in tutorials and practical sessions.

Learning material is provided through videos, review notes, examples, and tutorial questions.