Database management systems
L Smith
6 points * First semester * Distance * Prerequisites: GCO7801
Overview of database management systems; introduction to the relational model; normalisation and relational design; ER modelling, object data modelling, Database Design Language; the hierarchical model; the network model; the fourth generation environment; database administration, database security and recovery, distributed databases and current trends in the field. Interactive SQL and embedded SQL in a third generation language (dBase IV).
Assessment
Two assignments: 30% * Examinations (3 hours): 70%
Prescribed texts
Rob P and Coronel C Database systems - Design, implementation and management Wadsworth, 1993
Pratt P J A guide to SQL 2nd edn, Boyd and Fraser, 1991
Senn J A The student edition of dBase IV version 1.1 Addison-Wesley, 1991