IS5102: Database Management Systems
This module is offered in 2023-24.
Aims
The aims of this module are:
- To study database design.
- To study data models.
- To study database management systems.
- To study database theory.
Learning Outcomes
On successful completion of this module, the student should:
- Have gained knowledge and understanding of what is involved in the design of a database.
- Have gained knowledge and understanding of the models used for structuring data in database systems.
- Be able to implement a database and report on the process.
- Be able to query a database.
Syllabus
- Introduction
- Data Models
- Relational model
- Entity-relationship model
- SQL
- Data Manipulation Language (DML)
- Data Definition Language (DDL)
- Data Control Language (DCL)
- Database Implementation
- Security and Integrity
- Violation, authorisation and views, integrity constraints
- Database Development Lifecycle
- Database Design
- Functional dependencies
- Normalisation
- Database System Development
- Data Warehouses
- Beyond the relational model
- Business intelligence
- Data mining
Compulsory Elements
This module has no compulsory elements beyond those common to all modules (mark of 4 in each assessment component).