Database management systems
L Smith
6 points * 4 hours per week * Second semester * Gippsland/Distance * Prerequisites: GCO2811 or GCO1812 * Prohibitions: BUS2112, CFR2132, CFR3203, COT2132, COT2138
Overview of database management systems; introduction to the relational model; relational algebra, normalisation and relational design; ER modelling, Semantic Data modelling, advanced features of the relational model; Database Design Language; the hierarchical model; the CODASYL model; alternative data models; physical database design; fourth generation environment; database administration, database recovery, distributed databases and current trends in the field. SQL; embedded SQL in a third generation language (COBOL or C). Access to the university's computer systems via modem is compulsory for distance education students.
Assessment
Examination (3 hours): 70% * 3 design/programming assignments: 30%
Prescribed texts
Pratt P J and Adamski J J Database systems: Management and design 3rd edn, Boyd and Fraser, 1994
Pratt P J A guide to SQL 2nd edn, Boyd and Fraser, 1991