|Module Title||DATABASE AND DATA ANALYSIS|
|Co-ordinator||Dr Mark B Ratcliffe|
|Other staff||Dr Horst Holstein|
|Pre-Requisite||CS10610 or equivalent, CS12420 or CI12420, only available to students following Internet Computing schemes.|
|Course delivery||Lecture||22 lectures|
|Practical||up to 11 x 2hours|
2. Relational Modelling I - 4 Lectures
Entities and relationships. Connection traps. The design of relations. Transformation of an E-R model into a relational schema.
3. The Relational Model - 4 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. SQL2 and implementation - 2 Lectures
Introduction. Status. DDL statements. SELECT clauses. Constraints. Built-in functions. Queries and views. Nested SELECT.
5. Introduction to Object Databases - 2 Lectures
Perceived weaknesses of the relational model. Possible benefits of an object model. ODMG model.
6. Building and Manipulating Object Databases - 3 Lectures
Design; use of the UML. ODL and database aspects of CORBA. OQL and OML.
7. Object Relational Systems - 1 Lecture
Comparisons of relational and object systems. Object oriented extensions to relational systems. SQL3.
8. Building Applications - 1 Lecture
Integrity constraints. Introduction to transactions. Rollback.
9. Standard Interfaces - 1 Lecture
Forms; binding, GUI items, user support. Reports. Languages provided with DBMS.
10. Procedural Interfaces - 1 Lecture
DBMS connections and services. ODBC, JDBC. Application development. The data dictionary.
11. Large Scale DBMS - 2 Lectures
Concurrency. Security. Distributed Databases.
This module is at CQFW Level 6