Module Information
Course Delivery
| Delivery Type | Delivery length / details |
|---|---|
| Lecture | 20 hours |
Assessment
| Assessment Type | Assessment length / details | Proportion |
|---|---|---|
| Semester Assessment | Written assignment. This will involve a report of 3,000 words reflecting on an application of an Enterprise Database System. | 100% |
| Supplementary Assessment | Resubmit written assignment. | 100% |
Learning Outcomes
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.
Brief description
This module provides the understanding and skills necessary to build commercial database systems. This is done through studying commercial case studies of datablase systems and through the experience of building database systems in a commercial tool such as Oracle.
Content
- Introduction and business based case studies. (3 lectures)
- Commercial database application lifecycle: database planning; determining the requirements and defining the system; how is data captured and how it is deployed; Enterprise modelling; DBMS selection; implementation and data conversion; testing and maintenance. (8 lectures)
- Stored procedures; PL/SQI; Java. (1 lecture)
- Standard interfaces: report generators; form generators; integral web and application servers; RDBMS facilities. (2 lectures)
- Funcions of a multi-user database management system: concurrency control; recovery services; transaction support; integrity services. (3 lectures)
- Performance issues; monitoring and tuning databases; denormalisation; security of database systems. (3 lectures)
Module Skills
| Skills Type | Skills details |
|---|---|
| Application of Number | Inherent to subject. |
| Communication | Developed in written assignment. |
| Improving own Learning and Performance | Inherent to subject. |
| Information Technology | Inherent to subject. |
| Personal Development and Career planning | Will be developed in research. |
| Problem solving | Inherent to subject. |
| Research skills | Developed in written assignment. |
| Subject Specific Skills | Development of IT competence. |
| Team work |
Reading List
Recommended TextConnolly, Thomas & Begg, Carolyn (2004) Database Solutions Two Pearson Primo search
Notes
This module is at CQFW Level 5