Module Identifier CS10610  
Module Title DATABASES  
Academic Year 2003/2004  
Co-ordinator Dr Mark B Ratcliffe  
Semester Semester 1  
Other staff Mrs Janet H Hardy  
Co-Requisite Successful completion of an approved course on simple computer use and local facilities.  
Mutually Exclusive Not available to students who have database experience at A level or equivalent.  
Course delivery Lecture   22 lectures  
  Practical   10 x 2 hours  
  Other   Workshop. up to 11 x 1 hour  
Assessment TypeAssessment Length/DetailsProportion
Semester Exam1.5 Hours A1  50%
Semester Assessment A2 Continuous Assessment: One piece of assessed coursework (practical assignment)  50%
Semester Assessment A3 Practical Exercise: Regular worksheets with up to 10% penalty for non-completion of coursework element   
Supplementary Exam The resit assessment will, at the examining boards discretion, consist of an assignment to be carried out during the long vacation and/or a 1.5 hr written exam. 
Further details  

Learning outcomes

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

Brief description

On successful completion of this module, students will be familiar with the ideas used in database packages for personal computers and be able to design and construct a database using such a package to store and retrieve information of the type they will encounter in their studies.


This module provides an introduction to the use of a relational database management system so that:

The philosophy of the course will be to provide students with a tool and with techniques that they can use elsewhere in their studies. The practicals will be based on the microcomputer package Microsoft Access, and will develop problem solving and database design and implementation skills.


1. Introduction - 2 Lectures
The idea of a database, Database Management System and Database Application; a simple and a more complex example; records; fields; objects.

2. Tables and forms - 4 Lectures, 2 Practicals
The views of a table; field data types, properties; validation; primary keys and indexes; Access form wizards; varieties of form available; the views of a form; controls; tab order; visual design; forms for data entry.

3. Interrogating a Database - 3 Lectures, 2 Practicals
Simple search; wildcards; filters and select queries; crosstab, parameter, groups and totals queries. Elementary SQL for queries.

4. Reports - 1 Lecture, 1 Practical
Access report wizards; varieties of report; the views of a report; controls.

5. Multi-table databases - 4 Lectures, 3 Practicals
Entity-relationship modelling: entities, attributes, relationships, many-to-many relationships. Primary and foreign keys. Derivation of a set of tables from a model.

6. Normalisation - 4 Lectures
Data redundancy, inconsistencies, modification anomalies. Relational integrity. Functional dependencies. 1st, 2nd,3rd Normal Forms. Implementation in Microsoft Access. Improving and modifying a database.

7. Other Database Management System Facilities - 2 Lectures
Security issues; introduction to transaction processing.

8. Debriefing - 2 Lectures
Some lecture time each week will be devoted to a debriefing on the previous practical. Two of the practical sessions will be allocated to work on the assignments, but students should expect to have to spend further time on their assignments.

Reading Lists

Thomas M Connolly and Carolyn E. Begg (2000) Database Solutions: A step-by-step approach to building databases. 1. Addison -Wesley ISBN 0-201-67476-9
** Consult For Futher Information
David M. Kroenke (1999) Database Processing: Fundamentals, design and implementation. 7th edition. Prentice Hall ISBN 01 30848166


This module is at CQFW Level 4