Database Systems module (AC52001)

Learn how to create databases that can power software applications.

On this page


Module code


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 provide you with a solid foundation 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, and how to design and implement database solutions for them
  • explore alternative database models, such as hypermedia or real-time databases
  • investigate the legal 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
  • demonstrate your understanding of legal and professional issues relation to databases, such as data protection legislation
  • apply these skills to real-world scenarios

Assignments / assessment

  • database design coursework (15%)
  • database implementation coursework (35%)
  • class tests (10%)
  • formal examination (50%)

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.

Week Topics covered
1 Conceptual Database Design / ER Diagrams
2 Physical Database Design
4 Views / Transactions / Distributed Databases
5 Security / Ethics / PHP as a database interface
6 Data Warehousing
7 Online Analytical Processing (OLAP) / Data mining
8 Hypermedia and Graph Databases
9 Multimedia Databases
10 Real-time and Object-Oriented Databases
11 Revision


This module is available on following courses: