The aim of this module is to provide learners with: - A basic grounding in relational database technology - A knowledge and understanding of good database design - A knowledge and understanding of the basic functions of a DBMS, transaction processing and SQL query processing
Relational Data Model
Basics of relational data model, its terminology, ANSI-SPARC three-layer architecture, relational concepts (primary key, functional dependency, foreign key, candidate key, nulls)
Database Design
Entity-relational modelling (entity types, entities, attributes, types of relationships, optionality), construction of relational tables from ER diagrams, normalisation of a database to 3rd normal form
Table Manipulation
Create tables, drop tables, alter tables, set up relationships between tables, define primary and foreign keys using a GUI
SQL
Data Manipulation (inserts, updates & deletes) Data Retrieval (Select statements, functions, joins)
Transaction Processing
Security and Data Integrity - Failure types, Integrity, ACID properties, Backup & Recovery, Data Validation, Concurrency Control, Implementation of Concurrency Control, Locking, Deadlock
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Formal Examination | 50 |
| Other Assessment(s) | 50 |