Module Title:   Database Systems (PG)

Module Credit:   20

Module Code:   CM-1006D

Academic Year:   2015/6

Teaching Period:   PG Computing Summer Semester

Module Occurrence:   A

Module Level:   FHEQ Level 7

Module Type:   Standard module

Provider:   Computer Science

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

Principal Co-ordinator:   Dr G Min

Additional Tutor(s):   Mr M J Ridley

Prerequisite(s):   None

Corequisite(s):   None

To provide an appreciation of the database approach by reviewing first generation models, studying relational and object models and surveying recent developments.

Learning Teaching & Assessment Strategy:
A combination of lecture/tutorials/lab sessions/directed study

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

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

Mastery of database systems and relational and object technology.

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

Ability to design a database, implement within RDVMS, and to query and modify data in a RDVMS.

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

Practical skills, methods and tools to construct database systems based on different models.

  Coursework   20%
  Coursework typically equally weighted analysis and design element and use of SQL element.
  Examination - closed book 3.00 80%
  Examination - closed book 3.00 100%
  Supplementary Exam

Outline Syllabus:
(1) The database approach philosophical basis of the database approach ANSI/SPARC architecture Overview of data models (network, hierarchical, relational, object-oriented) (2) Relational database systems relational data model (structural, manipulative and integrity parts) relational DBMS architecture relational database languages (SQL) (3) Logical database design data analysis (entity relationship modelling) data aggregation data design normalisation (4) Physical database design selection of physical structures and access mechanisms denormalisation (5) Housekeeping and administration concurrency control - locking protocols security, privacy, integrity and recovery professional issues - data protection (6) Object relational and object models (7) Distributed and multidatabase systems

Version No:  2