This course will cover the objectives of database management systems, the fundamentals of data modelling using entity relationship diagrams, normalization rules, and database design. The aim of the module is to enable students to identify user requirements, produce data models and design database systems that are realistic, flexible and efficient using a number of standard methodologies.
Database management systems; data modelling; Entity Relationship Diagrams; SQL; implementation of complex relationships between entities; database nornalisation; building database systems;
Database management systems
Introduction to DB management system, its functionalities, advantages and disadvantages of using a DBMS.
Data modelling in the database design process. Different data models used in a DBMS. Introduction to Relational model which is used in RDBMS.
Entity Relationship Diagrams
Concepts in ER: entities, relationship. Using ERD to represent the data aspect of a software system/database application.
Structured Query Language
DML (Select, Insert, Update, Delete data) - complex query, nested query. DDL
The necessity of data normalisation. Normalisation process, 1NF, 2NF, 3NF.
Design and implementation of database application
Using the current DBMS, create DB, create form, report, query.
The module will be taught using lectures, laboratory sessions and sample case studies
|Module Content & Assessment