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