Module Information
Course Delivery
| Delivery Type | Delivery length / details |
|---|---|
| Lecture | 5 Hours. |
| Practical | 15 Hours. |
Assessment
| 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.
Content
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. |
Notes
This module is at CQFW Level 4