Monash University Computing & Information Technology handbook 1995

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

COT7710

File organisation and database systems

J Daly

6 points * 4 hours per week * First/Second semester * Caulfield * Prerequisites: COT7700 and SYS7510

Data organisation and storage: serial and sequential files (sorting, merging, updating, blocking). Randomly addressable secondary storage: suitable media, disc addressing, disc directories. Random files: key transforms, relative files, allocation of file space, overflow techniques. Indexed files: indexed random files, indexed sequential files, access methods, index trees. Logical data organisation: trees networks, lists, rings. Database: the database concept, database models, relational data model. Using SQL: data definition commands, retrieval commands, security commands, data dictionary commands, embedded commands.

Assessment

Examination (2 hours): 50% * Practical work: 50%

Prescribed texts

McFadden F R and Hoffer J A Modern database management 4th edn, Benjamin-Cummings, 1994


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