CPE2005

Database Systems in Networked Environments

(IT)

C Clemence

6 points + 4 hours per week + First and second semesters + Peninsula + Prerequisites: 24 points of 1st Yr Network Computing study + Prohibitions: CFR2201.

Synopsis: Basic Concepts. Database Architecture: schema and the ANSI three schema architecture. Data independence, DBMS languages, interfaces. Metadata. The client-server paradigm. Relational Model: data structure, data integrity and data manipulation. Relational database design. Data Modelling. Weak entities. Notation. Data structure diagrams. Normalisation. SQL: language components, DDL, DML, VDL, SDL. Relationship to three schema architecture. Tables and views. Constraints. Enforcing integrity. The system catalogue. Transactions: transaction concepts. ACID properties. Interleaving, lost updates, temporary updates, unrepeatable reads. Serialisability. Commits and rollbacks. Recovery concepts.

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