4533 (v.4) Database Systems 252
Area: | School of Computing |
Contact Hours: | 4.0 |
Credits: | 25.0 |
Lecture: | 1 x 2 Hours Weekly |
Practical: | 1 x 2 Hours Weekly |
Prerequisite(s): | 1922 (v.6) Software Technology 152 or any previous version
|
Introduction to database systems, Relational model and basic SQL, ER model, ER to relational mapping. Advanced SQL, SQL Programming, Triggers, Relational algebra, Normalisation, Data and Index Organisation, Relational query optimisation, Concurrency control, Crash recovery. |