This module provides an introduction to the field of databases. It covers the theory of their design, construction and manipulation through the Structured Query Language.
Understand the limitations of the traditional file-based approach and how database systems overcome these limitations.
Demonstrate knowledge and understanding of the components and the typical functions of Database Management Systems.
Demonstrate familiarity with the structure, the integrity rules and the manipulation of databases based on the Relational Data Model.
Understand the principles of logical database design and will be able to produce a design model using Entity-Relationship(E-R) diagrams and Normalisation.
Explain how multi-user databases facilitate concurrent access to data, recover from failures, and implement security policies.
Create a Relational Database, write SQL statements to query the data stored in a this database and connect to this database using a high level programming language.