Module Information

Module Identifier
Module Title
Academic Year
Semester 2
Other Staff

Course Delivery

Delivery Type Delivery length / details
Lecture 5 Hours.
Practical 15 Hours.


Assessment Type Assessment length / details Proportion
Semester Assessment Group Project  80%
Semester Assessment Individual assessment  20%
Supplementary Assessment Individual project  50%
Supplementary Assessment Essay  50%

Learning Outcomes

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

*Describe the main components of database systems

*Distinguish between relational and flat-file systems and where these are appropriate

*Evaluate a database problem into constituent parts

*From a deconstructed database problem design a solution using a relational database as part of a solution

*Demonstrate ability in the use of database elements including the use and creation of tables, forms, queries, reports, relational links.

*Critically evaluate the process of database design and construction as experienced in their team working and coursework.

Brief description

A problem based approach to the teaching and learning of database design. Working from an initial problem or scenario students will work through design issues and implementation using tables, relationships, queries reports, forms and the related issues that these raise.


Defining the database problem, what is a database, and how do we move from an ill defined need through to a working database.
Content will cover four areas:
1) Design elements: Design theory, Planning,
2) Practical elements: Elements of database construction including Tables, Forms, Relational links, Queries, Reports.
3) Working in teams to accomplish database design and implementation.
4) Evaluating databases.

Module Skills

Skills Type Skills details
Application of Number Development of a basic understanding of logic and mathematical functions will be part of the course and completing the coursework.
Communication Report writing, team communication and discussion will be necessary for completion of this course.
Improving own Learning and Performance Students will be made conscious of the issues of working in teams to complete a practical project. Self reflection will be encouraged.
Information Technology Databases necessarily involve the use of information technology, and development of advanced computing skills.
Problem solving Analytic problem solving skills will be developed
Subject Specific Skills Skills relating specifically to the design and creation of a Microsoft Access database.
Team work Team work will be a vital part of the production of the database and practical sessions. This will not be directly assessed.


This module is at CQFW Level 4