|| IL11420 |
|| DATABASE DESIGN AND MANAGEMENT |
|| 2007/2008 |
|| To Be Arranged |
|| Semester 2 |
| Course delivery
|| Lecture || 5 Hours. |
|| Practical || 15 Hours. |
Learning outcomesOn 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.
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.
|| Analytic problem solving skills will be developed |
|| 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 will be a vital part of the production of the database and practical sessions. This will not be directly assessed. |
|| 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. |
** 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
This module is at CQFW Level 4