Skip to content | Change text size

GCO9804

Database management systems ( 6 points, SCA Band 2, 0.125 EFTSL)

Postgraduate
(IT)

Leader: S Teng

Offered:
Gippsland First semester 2005 (Day)
Gippsland First semester 2005 (OCL)
Thailand First semester 2005 (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%

Prohibitions: GCO2815, BUS2112, CFR2132, CFR3202, COT2132, COT2138, IMS2112, IMS9003