F D Rolland, The Essence of Databases, Prentice Hall, 1998, ISBN: 0137278276
(Essential Reading)
Date C J, Database System, 8th Edition Vol 1, Addison-Wesley 2004, ISBN: 0321189566
(additional reading)

ORACLE relational database mangement system
The Library
ITS and Computing Labs
Internet information server supporting ASP
Web Browser

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 12 lectures and 24 tutorial/practical sessions, the latter normally delivered to groups of 20 students per tutor.
(1:n)1 (1:20)2

None.

A coursework portfolio weighted at 100% comprising:-
A Class test length .75 hours weighted at 40%.
An Assignment weighted at 60%.

A class-test 45 minutes weighted at 40% which will assess Learning Outcome 3. The test will be machine based and take place in normal class hours.
An assignment weighted at 60% which will assess Learning Outcomes 1, 2 and 4.

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 system architecture - relational, network, hierarchical, object orientated.
Database reliability, integrity and concurrency control.
Introduction to client server web databases using ASP.
Introduction to XML and related database technologies.