CFR7112

Relational database technology

C Clemence

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

Objectives At the completion of this subject students should understand the ANSI architecture for relational database management systems (DBMS) and the benefits that flow from the architecture; understand relational algebra, relational calculus and their relationship to structured query languages (SQLs), underlying data structures of DBMS, concurrency and transaction boundaries on the manipulation of data in the database, embedded SQL, object-oriented data models; and be able to formulate non-trivial SQL statements to define the structure of a database, manipulate the data within it and to control access to that data.

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

Elmasri R and Navathe S Fundamentals of database systems 2nd edn, Benjamin Cummings, 1994