Module Information

Module Identifier
CS27510
Module Title
Commercial Database Applications
Academic Year
2014/2015
Co-ordinator
Semester
Semester 2
Pre-Requisite
Other Staff

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 Text
Connolly, Thomas & Begg, Carolyn (2004) Database Solutions Two Pearson Primo search

Notes

This module is at CQFW Level 5