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
Assessment TypeAssessment Length/DetailsProportion
Semester Exam2 Hours  100%
Supplementary Exam Will take the same form, under the terms of the Department's policy   

Learning outcomes

On successful completion of this module, students will be able to:

Brief description

This module develops the concepts of database design and implementation. The emphasis is on relational systems but object databases are introduced. It covers practical topics concerned with modelling and effective use of the facilities provided by a modern Database Management System (DBMS). Theoretical topics include data modelling, placing particular emphasis on the data model, relational algebra and the realisation of the relational model in a DBMS.

Content

1. Database System Concepts - 1 Lecture
Persistence. Outline history: file-based, network, relational and object-based systems. Databases, DBMS and applications programs. DBMS as reuse.

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.

Reading Lists

Books
** Recommended Text
Thomas Connolly and Carolyn Begg (2001) Database Systems: A practical Approach to Design, Implementation and Management 3rd. Addison-Wesley ISBN: 0201342871

Notes

This module is at CQFW Level 6