Monash University Computing & Information Technology handbook 1995

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

COT4230

Relational database systems

M Nolan

6 points * 4 hours per week * First/Second semester * Caulfield

Objectives of database technology, data sharing, data independence, data integrity and data security, three-schema architecture. The relational data model: structures, domains, relations and attributes. Integrity constraints: entity, referential and user-defined integrity. Operations: relational algebra, relational calculus, domain and tuple calculus. Relational database design: conceptual design, logical design, physical design. Major SQL and relational systems. Network DBMS versus relational DBMS.

Assessment

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

Prescribed texts

Elmasri R and Navathe S B Fundamentals of database systems Benjamin-Cummings, 1989

Hawryszkiewycz I T Database analysis and design 2nd edn, Maxwell-Macmillan, 1991


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