CPE2005

Database systems ( 6 points, SCA Band 2, 0.125 EFTSL)

Leader: C Clemence

Offered:
Peninsula First semester 2006 (Day)
Peninsula SA-02 2006 (Day)
Peninsula Second semester 2006 (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.