The concept of a DBMS and DB Architectures are introduced. This module will build
upon the notion of a database as introduced in Information Modelling and
Specification including revision of those concepts previously introduced, i.e. the
relational data model, including issues, such as Integrity Constraints, SQL, and Views.
- Concepts of databases and DBMSs;
- Database Architectures;
- Revision of the Relational Model; SQL Tables, Views and the DDL; Referential and
Existential Integrity Constraints;
- Normalisation: Functional Dependencies; 1st, 2nd 3rd, 4th Boyce Codd and Fifth
Normal Forms;
- Technologies: Transaction Management; ACID properties; Security; Data Storage &
Indexing; Triggers & Active DBs; Query Optimisation; Distributed Architectures;
- Use of embedded SQL, cursors, triggers;
- Object DBs and Object Relational DBs;
- Data Warehousing, Decision Support & Data Mining;
- Emerging Technologies;