Module Identifier | CI37310 | |||||||||||
Module Title | DATABASE AND DATA ANALYSIS | |||||||||||
Academic Year | 2003/2004 | |||||||||||
Co-ordinator | Dr Mark B Ratcliffe | |||||||||||
Semester | Semester 2 | |||||||||||
Other staff | Dr Horst Holstein | |||||||||||
Pre-Requisite | CS10610 or equivalent, CS12420 or CI12420, only available to students following Internet Computing schemes. | |||||||||||
Mutually Exclusive | CS27310 | |||||||||||
Course delivery | Lecture | 22 lectures | ||||||||||
Practical | up to 11 x 2hours | |||||||||||
Assessment |
|
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