Module 06-28936 (2018)

Introductory Databases

Level 2/I

Outline

The module begins with a swift recap of the standard database canon: SQL and ER modelling, albeit from a more advanced perspective. This is followed by a discussion of relational algebra and functional dependencies, and their role in verifying and improving the ER model (towards Boyce-Codd normal form). In the second part of the module, the inner workings of a database management system are presented and it is discussed how they impact on query evaluation efficiency. In the final part, transactions and transaction processing will be discussed.

Aims

The aims of this module are to:

Learning Outcomes

On successful completion of this module, the student should be able to: