Module Identifier | CS27420 | ||||||||||||||||||||
Module Title | Commercial Database Solutions | ||||||||||||||||||||
Academic Year | 2007/2008 | ||||||||||||||||||||
Co-ordinator | Mr Rhys Parry | ||||||||||||||||||||
Semester | Semester 2 (Taught over 2 semesters) | ||||||||||||||||||||
Other staff | Mr Rhys Parry, Mr Richard C Shipman, Mr David J Smith | ||||||||||||||||||||
Co-Requisite | CS27020 | ||||||||||||||||||||
Course delivery | Lecture | Up to 40 lectures | |||||||||||||||||||
Seminars / Tutorials | 11 two hour practical sessions | ||||||||||||||||||||
Assessment |
| ||||||||||||||||||||
Further details | http://www.aber.ac.uk/compsci/ModuleInfo/CS27420 |
This module will provide material that will enable the students to grasp the commercial potential of database technology, and understand how to apply it in specific business situations.
It will advance their knowledge of SQL programming.
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; 11 practicals)
Stored procedures; PL/SQl; Java. (1 lecture)
Standard interfaces: Report generators; form generators; integral web and application servers; RDBMS facilities.(2 lectures)
Functions of a multi-user database management system: concurrency control; recovery services; transaction support; integrity services. (4 lectures)
Performance issues: Monitoring and tuning databases; denormalisation; security of database systems. (4 lectures)
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 | ||
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. | ||
Team work | Assessed on other modules during the second year (CI22120). | ||
Information Technology | The module is IT focused. Students will use computer tools to develop and run their applications | ||
Application of Number | No | ||
Personal Development and Career planning | The module gives students a wider view of the computing industry and potential careers. | ||
Subject Specific Skills | Methodological skills, design skills, programming skills |
This module is at CQFW Level 5