Entity models, relational design, mapping designs to implementations, normalisation and de-normalisation.
Database languages i.e. SQL: DML, DDL and DCL and PL/SQL
Developing applications with appropriate database portal tools
Database reliability, integrity and concurrency control.
Introduction to client server web databases using ASP.
Introduction to XML and related database technologies.
Globalisation and localisation issues within database

A coursework portfolio weighted at 100% comprising:-
An assessment in two parts:
Part 1 (40%) A design and justification report based on a given scenario. (Learning outcomes 1 and 4)
Part 2 (60%) A build and reflection of the system designed in part 1.
(Learning outcomes 2 and 3)

Designing Effective Database Systems
(Available as e-book in University library)
By: Rebecca M. Riordan
Publisher: Addison-Wesley Professional
Pub. Date: January 10, 2005
Print ISBN-10: 0-321-29093-3
Print ISBN-13: 978-0-321-29093-9

ORACLE relational database management system
The Library
ITS and Computing Labs

None.

The module aims to allow you to work in your own time at your own pace, with lecturers being available during the two set tutorial/practical sessions each week to offer assistance where required. Extensive use is made of the technique of learning via problem solving with each student having their own database account. The course relies heavily on prescribed reading with lectures supporting you in difficult areas. You will be able to identify the extent and type of help you require from these sessions by active learning self assessments which will be provided as an integral part of the module. There will be 13 lectures and 26 tutorial/practical sessions, the latter normally delivered to groups of 20 students per tutor. (1:n)1 (1:20)2