|Module Title||COMMERCIAL DATABASE APPLICATIONS|
|Co-ordinator||Mr Rhys Parry|
|Semester||Semester 2 (Taught over 2 semesters)|
|Other staff||Mr Rhys Parry, Professor Christopher J Price, Mr Richard C Shipman|
|Course delivery||Lecture||up to 20 hours|
|Seminars / Tutorials||11 two hour practical sessions|
It will significantly expand their practical experience of building databases, grounding that experience in the application of a commercial database tool (for example, Oracle).
It 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; conceptual, logical and physical database design; application design; DBMS selection; implementation and data conversion; testing and maintenance. (8 lectures; 6 practicals)
Stored procedures; PL/SQl; Java. (1 lecture; 2 practicals)
Standard interfaces: Report generators; form generators; integral web and application servers; RDBMS facilities.(2 lectures; 2 practicals)
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