This module provides the student with a comprehensive introduction to conceptual data modelling for database design, sound understanding of the relational model, and practical knowledge of querying SQL databases and expressing relational schemata in SQL.
The module content will include the following topics. Material may be added to or deleted from this list over the lifetime of the module to reflect the changing nature of the relevant technologies.
- Disk Storage, Basic File Structures
- Databases and Database Users
- Database System Concepts and Architecture
- The Relational Data Model and Relational Database Constraints
- SQL
- Data Modelling Using the Entity-Relationship (ER) Model
- The Enhanced Entity-Relationship (EER) Model
- Relational Database Design by ER and EER-to-Relational Mapping
- Dependencies and Normalization
This module can be delivered either through standard delivery or blended delivery.
In standard delivery this module is delivered through a series of lectures with associated practical assignments.
In blended delivery this module is delivered through a series of live or recorded lectures with associated laboratory work and practical assignments.
Both blended and standard delivery have the same overall number of teaching and self-directed learning hours.
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Formal Examination | 70 |
| Other Assessment(s) | 30 |