Relational database
G Martin
8 points
* 4 hours per week
* First semester
* Clayton
*
Prerequisites: BUS1010, COT1700
* Prohibitions: BUS2112, CFR2132, CFR2201,
COT2132, COT2138, COT2901, COT3180, CSC3161
Objectives At the completion of this subject students should be able to demonstrate knowledge of the function and use of the relational database model; perform operations with a relational database application; discuss the function and theory of relational databases and their application to information management; and demonstrate knowledge of issues associated with relational databases.
Synopsis 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
McFadden F R and Hoffer J A Modern database management 4th edn, Benjamin-Cummings, 1994
Pratt P J Microcomputer database management using dBase IV Boyd and Fraser, 1988
| Published by Monash University, Clayton, Victoria
3168 Copyright © Monash University 1996 - All Rights Reserved - Caution Authorised by the Academic Registrar December 1996 |