CPE2005 - Database systems

Leader: David Taniar

Offered

Caulfield Second semester 2007 (Day)

Synopsis

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.

Assessment

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

Contact hours

4 hours per week

Prerequisites

18 points of 1st Yr Network Computing study

Prohibitions

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