Database Management
Description
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. Project based learning is used to give practical experience and to reinforce the concepts introduced.
Learning Outcomes
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.
Write SQL statements to query the data stored in a Relational database, create database tables and, insert data into these tables.
Use a forms-based system to create basic forms for accessing a relational database.