Module Identifier | CS27020 | |||||||||||||||||
Module Title | DATABASE MANAGEMENT SYSTEMS | |||||||||||||||||
Academic Year | 2006/2007 | |||||||||||||||||
Co-ordinator | Mr Nigel W Hardy | |||||||||||||||||
Semester | Semester 2 (Taught over 2 semesters) | |||||||||||||||||
Other staff | Dr Horst Holstein, Mr Nigel W Hardy, Mr Richard C Shipman | |||||||||||||||||
Pre-Requisite | CS10610 (or equivalent), CS12230 or CS12320 (or equivalent) | |||||||||||||||||
Course delivery | Lecture | up to 44 Hours. | ||||||||||||||||
Seminars / Tutorials | Regular exercises: up to 8 | |||||||||||||||||
Assessment |
| |||||||||||||||||
Further details | http://www.aber.ac.uk/compsci/ModuleInfo/CS27020 |
Review and persistence, outline history. The value of general models: relational; object oriented; semi-structured. Databases, DBMS and applications programs. DBMS as reuse.
2. Relational Modelling I - 6 Lectures
Entities and relationships. Connection traps. The design of relations. Transformation of an E-R model into a relational schema. Use of UML.
3. The Relational Model - 6 Lectures
Domains, relations and tuples. Primary and foreign keys. Referential integrity. Relational algebra. Null values and the outer join. Data normalisation. Validating a design.
4. SQL and implementation - 5 Lectures
Introduction. Status. DDL statements. SELECT clauses. Constraints. Built-in functions. Queries and views. Nested SELECT. Stored procedures.
5. Additional relational integrity constraints - 2 Lectures
Table and database level constraints. Triggers. Use of stored procedures.
6. Transactions - 1 Lectures
Introduction to transactions. ACID properties. Rollback.
7. Integration with general high level languages - 2 Lectures
Embeddings and APIs. DBMS connections and services. ODBC, JDBC. Application development. The data dictionary.
8. Introduction to Object Databases - 2 Lectures
Perceived weaknesses of the relational model. Possible benefits of an object model. ODMG model.
9. Object Relational Systems - 4 Lectures
Comparisons of relational and object systems. Object oriented extensions to relational systems. SQL3.
10. The semi-structured database model and XML - 5 lectures
The model: outline; perceived advantages. The XML standard. XMLSchema: overview; type constraint; keys and keyrefs; comparison with SQL. XPath and XQuery: syntax; power. XML databases: native databases; extensions to RDBMS.
11. Mixed solutions - 4 lectures
Relational/XML/object library mappings. Tools to generate mappings.
12. Large Scale DBMS - 3 Lectures
Concurrency. Security. Distributed Databases.
Communication | Requirements analysis is a major component. This requires careful and insightful reading and analysis of ¿customer¿ documents, followed by reflection of requirements back to the customer to verify mutual understanding. | ||
Improving own Learning and Performance | Systematic and comprehensive analysis and design require good workjing practices, which are explored in the module. | ||
Information Technology | Database systems are central to much IT. | ||
Subject Specific Skills | Use of UML (industry standard modelling language). Use of SQL and XML languages, plus additional aspects of Java. Experience of a major DBMS. |
This module is at CQFW Level 5