Leader: C Clemence
Peninsula First semester 2005 (Day)
Peninsula Second semester 2005 (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