Overview
Academic contacts
Offerings
Requisites
Other learning activities
Learning activities
Learning outcomes
Apply your knowledge of relational database principles and theory to create effective and efficient database designs
Define, create and manage relational database systems using SQL
Design and implement a database to a given specification using a DBMS
Explain the issues associated with, and compare candidate solutions for, the processing of concurrent database transactions
Formulate and implement constraints appropriate for a range of commonly encountered database security scenarios
Differentiate between non-relational and relational approaches to managing data
Assessments
Additional information
The unit material is divided into a number of topics. The following topics will be covered: • Introduction to databases and the relational model • Database query languages • Normalisation • Database design • Transaction management • Database architectures • Database security • Data warehouses • An introduction to non-relational databases