GCO2815

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

Leader: S Teng

Offered:
Gippsland First semester 2005 (Day)
Gippsland First semester 2005 (OCL)
Hong Kong First semester 2005 (OCL)
OS-HKG-CID First semester 2005 (OCL)
Singapore 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; Transaction management; concurrency control; introduction to distributed, object-oriented and object-relational database systems.

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

Contact Hours: 4 hours per week

Prerequisites: GCO1810 or GCO1811

Prohibitions: BUS2112, CFR2132, CFR3203, COT2132, COT2138, IMS2112, IMS9003