CPE2005

Database Systems in Networked Environments

(IT)

6 points + 4 hours per week + first, second and summer semester + Peninsula + Prerequisites: CPE1002, CPE1004, CPE2003 + 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 catalog. 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%