IS5102: Database Management Systems
This module is offered in 2020-21.
The aims of this module are:
- To study database design.
- To study data models.
- To study database management systems.
- To study database theory.
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.
- Data Models
- Relational model
- Entity-relationship model
- 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
- Database System Development
- Data Warehouses
- Beyond the relational model
- Business intelligence
- Data mining
This module has no compulsory elements beyond those common to all modules (mark of 4 in each assessment component).