Skip to content | Change text size

CPE2005 - Database systems

6 points, SCA Band 2, 0.125 EFTSL

Undergraduate Faculty of Information Technology

Leader: David Taniar


Caulfield Second semester 2007 (Day)


Basic Concepts: database characteristics and technology, data models, data abstraction, controlling redundancy, integrity. Database Architecture. Data independence. The client-server paradigm. Relational Model. Relational database design. Data Modelling. Weak entities. Notation. Normalisation. SQL: language components, DDL, DML. Tables and views. Constraints. Enforcing integrity and business rules. Triggers, procedures and functions. The system catalogue. Transaction concepts. Interleaving, lost updates, temporary updates, unrepeatable reads. Serialisability. Commits and rollbacks. Recovery concepts.


Examination (3 hours): 60%
Practical work: 40%

Contact hours

4 hours per week


18 points of 1st Yr Network Computing study


BUS2112, CFR2132, CFR2201, COT2132, COT2138, COT2180, COT2901, COT3180, CSE2132, CSE2138, CSE2180, CSE3180, CSC3161, CSE3316, GCO2815, MMS2801, IMS2112, IMS1907.