Database management systems
L Smith
6 points * 4 hours per week * First semester * Gippsland/Distance * Prerequisites: GCO2851 and GCO2852, or GCO1813 and GCO1832 * Note: This subject is not available to computing students
Overview of database management systems; introduction to the relational model; normalisation and relational design; ER modelling, Object Data modelling, Database Design Language; the hierarchical model; the network model; the fourth generation environment; database administration, database security and recovery, distributed databases and current trends in the field. Interactive SQL and embedded SQL in a third generation language (dBase IV). For distance education students there is an optional four hours contact at each weekend school, coupled with study guides and provision for additional student contact through phone, fax and electronic mail.
Assessment
Assignments: 30% * Examination 70% * Note that a satisfactory level of achievement is required in both components to obtain a pass
Prescribed texts
Rob P and Coronel C Database systems - Design, implementation and management Wadsworth Publishing, 1993
Pratt P J A guide to SQL 2nd edn, Boyd and Fraser, 1991
Senn J A The student edition of dBase IV version 1.1 Addison-Wesley, 1991