GCO9804

Database management systems (6 points)

(IT)

Leader: K M Ting and G Chetty

Offered:
Gippsland First semester 2004 (OCL)
Singapore First semester 2004 (OCL)
Gippsland Second semester 2004 (OCL)

Synopsis: Overview of database management systems; DBMS file structures; introduction to the relational model; relational algebra and calculus, query optimization; normalisation and relational design; ER modelling, object-oriented modelling, advanced features of the relational model; Database Design Language; physical database design; fourth-generation environment; database administration, database recovery and current trends in the field. Relational query languages; SQL; embedded SQL. Transaction management; concurrency control; introduction to distributed, object-oriented and object-relational database systems.

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

Prerequisites: GCO9801 or BUS9520