GCO2815

Database management systems (6 points)

(IT)

Leader: K M Ting and G Chetty

Offered:
OS-HKG-CID 1-60 2003 (OCL)
Gippsland First semester 2004 (Day)
Gippsland First semester 2004 (OCL)
Hong Kong First semester 2004 (OCL)
Malaysia First semester 2004 (Day)
Singapore First semester 2004 (OCL)
Gippsland Second semester 2004 (Day)
Gippsland Second semester 2004 (OCL)
Singapore 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%

Contact Hours: 4 hours per week

Prerequisites: GCO1810 or GCO1811

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