Module Title:   Database Systems

Module Credit:   20

Module Code:   CM-0229L

Academic Year:   2015/6

Teaching Period:   Semester 1

Module Occurrence:   A

Module Level:   FHEQ Level 5

Module Type:   Standard module

Provider:   Computer Science

Related Department/Subject Area:   SCIM (Dept of Computer Science)

Principal Co-ordinator:   Mr M.J.Ridley

Additional Tutor(s):   Dr P. Trundle

Prerequisite(s):   CM-0117D

Corequisite(s):   None

Aims:
To provide a co-ordinated and consistent coverage of theory, design and development of database systems and their role in building software systems.

Learning Teaching & Assessment Strategy:
The contact time consists of lectures, tutorials and laboratory study. The remainder is given over to private study comprising directed reading, unsupervised laboratory exercises, and coursework assignments.
Students requiring supplementary assessment will repair deficiencies in the original assessments and/or undertake supplementary examination.

Lectures:   12.00          Directed Study:   137.00           
Seminars/Tutorials:   12.00          Other:   0.00           
Laboratory/Practical:   36.00          Formal Exams:   3.00          Total:   200.00

On successful completion of this module you will be able to...

Analyse the database approach and design and application considerations of using a RDMS in the development of software systems. Understand and apply the theory underlying relational database systems.

On successful completion of this module you will be able to...

Design a relational database and apply SQL to query and modify data in a RDBMS.

On successful completion of this module you will be able to...

Design relational database systems, and implement database systems using SQL.

  Coursework   25%
 
  Two exercises involving the design of a relational database system and use of SQL
  Examination - closed book 3.00 75%
 
  Examination

Outline Syllabus:
The database approach: advantages and costs; how it contrasts with the conventional file oriented approach. The relational model: what a data model is; the structural part of the relational model (structure of tables, attributes, tuple and keys); the relational algebra; entity and referential integrity rules; architecture of a relational database management system (RDBMS) and its relationship to the relational model; SQL: data query from single and multiple tables. Database design: entity relationship modelling; relational data design; functional dependence; normalisation; physical data design. Database housekeeping: security; concurrency; integrity; database administration. Use of a proprietary relational database management system. Limitations of the relational model: the gap between theory and practice; a survey of advanced database systems.

Version No:  1