GCO9804

Database management systems

(IT)

L F Smith

6 points + Second semester + OCDL + Prerequisites: GCO9801 or equivalent

Synopsis: Introduction to database systems. The relational data model & DBMS record structures. Relational algebra, advanced features of relational model. DB design techniques: entity relationship (ER) modelling, normalization, Database Design Language (DBDL). Alternative data models: CODASYL model, Hierarchical model. Physical DB design. Relational query languages, SQL, application development via embedded SQL. DB administration, security. Transaction management, concurrency control, Query execution. DB recovery. Overview of distributed DB systems and object oriented DB systems. Access to the university's computer systems is compulsory.

Assessment: Assignments: 40% + Examination (3 hours): 60%