Module Identifier IL11420  
Module Title DATABASE DESIGN AND MANAGEMENT  
Academic Year 2005/2006  
Co-ordinator To Be Arranged  
Semester Semester 2  
Course delivery Lecture    
  Practical    

Learning outcomes

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






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.

Content

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

Problem_solving Analytic problem solving skills will be developed  
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.  
Team work Team work will be a vital part of the production of the database and practical sessions. This will not be directly assessed.  
Information Technology Databases necessarily involve the use of information technology, and development of advanced computing skills.  
Application of Number Development of a basic understanding of logic and mathematical functions will be part of the course and completing the coursework.  
Subject Specific Skills Skills relating specifically to the design and creation of a Microsoft Access database.  

Reading Lists

Books
** Recommended Text
Connolly, T.M. and Begg, C.E. Database Solutions: a step-by-step approach to building databases
Fernald, A.C. Database Design: an introductory guide to planning and creating a database
Roman, S. Access database design and programming

Notes

This module is at CQFW Level 4