MONASH UNIVERSITY FACULTY HANDBOOKS

Computing & Information Technology Handbook 1996

Published by Monash University
Clayton, Victoria 3168, Australia

Authorised by Academic Registrar, April 1996

CFR7112

Relational database technology

D Ceddia

6 points + 4 hours per week + First semester + Peninsula + Prerequisites: CFR7103 + Prohibitions: BUS2112, CFR2201, COT2901, COT3180, CSC3161

Synopsis Introduce the ANSI architecture of relational DBMS and data independence; use SQL to interface a database system. Consider the relationships between relational algebra, relational calculus and SQL; formulate queries in relational algebra. Examine the underlying data structures of DBMS, and the criteria for selecting suitable storage structures. Use rules and procedures to enforce database integrity. Consider other examples of data models for database systems.

Assessment Examination (2 hours): 60% + Assignment: 40%

Recommended texts

| Subjects | Computing & Information Technology Handbook | Monash handbooks | Monash University