Monash University Computing & Information Technology handbook 1995

Copyright © Monash University 1995
Enquiries to publishing@udev.monash.edu.au

COT2180

Relational database

R Simpson

8 points * First semester * Clayton * Prerequisites: BUS1010 and COT1700 * Prohibitions: BUS2112, CFR2132, CFR2201, COT2132, COT2138, COT2901, COT3180, CSC3161

This subject familiarises students with relational database theory, techniques and practice. Students will be made aware of a range of database concepts, such as structured information, serial storage, sequential file organisation, extracting, sorting, merging and updating data. Random access file organisation, random and relative file organisation, key transforms and indexing techniques will be addressed. The subject will also deal with logical data structures (such as trees, networks, lists and rings) and database models. The theory and practice of relational database management systems and, by contrast, the CODASYL approach, distributed databases, object-oriented databases will also be included. Students will be introduced to formal query languages, specifically SQL.

Assessment

Examination (2 hours): 50% * Practical work, laboratory work, seminar participation and assignment: 50%

Prescribed texts

Pratt P J Microcomputer database management using dBaseIV Boyd and Fraser, 1988


Return to subject list Return to computing handbook contents Return to the list of Monash handbooks