This course will cover the objectives of database management systems, the fundamentals of data modelling using entity relationship diagrams, normalisation rules, and database design. The students will apply the theory by implementing a solution to a business problem using a current database product
Data Analysis: Data modelling using Entity Relationship diagrams.
Entity, attribute, relationship, candidate key, primary key, foreign key.
Database Design: Using Entity Relational models to produce normalized tables; Implement one to one, one to many and many to many relationships.
Database Management Systems: Definition of a database and a database management system. The functions of a DBMS.
Historical development of Model Types - Hierarchical, Network, Relational and Object-Oriented.
Database software objectives. Independence, integrity, minimal redundancy, data sharing, control. Overview of current DBMS software facilities.
Laboratory work using a current DBMS: Creating tables. Creating relationships. Implementing Integrity constraints and validation rules. Join properties: Referential Integrity.
Cascade update and delete.
Creating the user interface: forms and subforms.
Querying the database select, parameter, and total queries. Creating user views. Generating reports.
Normalization: The aims of normalization. Functional Dependency and normalization to Boyce-Codd normal form.
The module is delivered through a combination of lectures and tutor lead IT labs. Additionally various elearning aids are used.
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Other Assessment(s) | 100 |