IY1H904 - Developing Databases for Business 16 Apr 2012 - 30 Sep 2017 | Version 1
Associated Module Information
| Module Code: | IY1H904 | ||
|---|---|---|---|
| Module Title: | Developing Databases for Business | ||
| Faculty: | Faculty of Computing, Engineering and Science | ||
| Faculty Group: | Computing and Mathematics | ||
| Faculty Sub Group: | Computing | ||
| Module Leader: | |||
| Module Team: | |||
| First Intended Intake: | NOV 2015 | Final Year of Intake: | |
| Date Closed: | |||
| Credit Value: | 10 | Credit Level: | 4 |
| Language: | English | ||
| Percentage of Module Taught in Welsh: | 0 | ||
| Equivalent Module: | |||
| HECOS codes: | |||
| HECOS Code Weighting: | |||
Document Version Information
| Version | 1 |
|---|---|
| Valid From | 16 Apr 2012 |
| Valid To | 30 Sep 2017 |
Module Aims
To be able to use the advanced features of the selected database application\\r
The module will provide specialist work based learning and up-skilling through the DEHOV project as part of the UHOVI (Universities Heads of the Valleys Institute) agenda.\\r
Content Summary
To understand key concepts of database design (ERM/Class diagrams) and development and use a relational database application to create an advanced database structure and outputs:\\r
Create a relational database using advanced table creation features with complex relationships between tables. \\r
Design and use queries, create tables, update, delete and append data. Refine queries using wildcards, parameters and calculations. \\r
Use controls and sub-forms to enhance forms and improve functionality. \\r
Create report controls to perform calculations. Create sub-reports and enhance report presentation. \\r
Enhance productivity by working with macros and use linking and importing features to integrate data. \\r
Practical or simulated implementation of the selected database package in the workplace. \\r
Create a relational database using advanced table creation features with complex relationships between tables. \\r
Design and use queries, create tables, update, delete and append data. Refine queries using wildcards, parameters and calculations. \\r
Use controls and sub-forms to enhance forms and improve functionality. \\r
Create report controls to perform calculations. Create sub-reports and enhance report presentation. \\r
Enhance productivity by working with macros and use linking and importing features to integrate data. \\r
Practical or simulated implementation of the selected database package in the workplace. \\r
Learning and Teaching Methods
Learning Outcomes
Module Requisites
N/A