| Delivery Type | Delivery length / details |
|---|---|
| Lecture | Up to 40 lectures |
| Seminars / Tutorials | 11 two hour practical sessions |
| Assessment Type | Assessment length / details | Proportion |
|---|---|---|
| Semester Assessment | Practical 1 (mainly formative) | 10% |
| Semester Assessment | Assessment is through 3 pieces of practical work, all of which will involve the use of a commercial DBMS : | |
| Semester Assessment | Practical 3. This will involve a report of 6,000 words reflecting on what was achieved, as well as practical programming work. | 80% |
| Semester Assessment | Practical 2 (mainly formative) | 10% |
| Supplementary Assessment | This will be through 1 practical assignment equivalent to Practical 3. | 100% |
On successful completion of this module students should be able to:
1. Describe and work through the stages of the database lifecycle.
2. Analyse where an enterprise might use a database application and how data is captured and deployed.
3. Present a business case for the use of an Enterprise database solution for a typical commercial application.
4. Identify where to use stored procedures and Enterprise application code to manipulate an Enterprise class database .
This module provides the understanding and skills necessary to build commercial database systems. This is done through studying commercial case studies of database systems and through the experience of building database systems in a commercial tool such as Oracle.
| Skills Type | Skills details |
|---|---|
| Application of Number | No |
| Communication | Assessed on other modules during the second year (CI22120). |
| Improving own Learning and Performance | The assessed coursework requires students to develop their understanding of issues associated with the module. |
| Information Technology | The module is IT focused. Students will use computer tools to develop and run their applications |
| Personal Development and Career planning | The module gives students a wider view of the computing industry and potential careers. |
| Problem solving | Deciding on an appropriate design when building a commercial database application |
| Research skills | Students will be required to acquire further knowledge from books and on-line sources |
| Subject Specific Skills | Methodological skills, design skills, programming skills |
| Team work | Assessed on other modules during the second year (CI22120). |
This module is at CQFW Level 5