Relational database technology
D Ceddia
6 points * 4 hours per week * First semester * Peninsula * Prerequisites: CFR7103 * Prohibitions: BUS2112, CFR2201, COT2901, COT3180, CSC3161
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
Elmasri R and Navathe S Fundamentals of database systems Benjamin-Cummings, 1989