Prior study of Systems Analysis and Design or equivalent coverage of basic SAD material.

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 eac 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.

A class-test length 45 minutes weighted at 50% which will assess Learnings Outcomes 1 and 3..
An assignment weighted at 50% which will assess Learning Outcomes 2 and 4.

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, students will require access to the SQL *PLUS and Developer 2000 products.
The Library
ITS and Computing Labs
Internet information server supporting ASP
Web Browser

Distributed database design: Entity models, relational design, mapping designs to implementations, normalisation and de-normalisation.
Database languages
SQL: DML, DDL and DCL
Developing applications with database tools
Database system architecture
Database security, reliability, integrity and concurrency control
Database administration: functions of database administration, organisational issues.
Introduction to ASP.
Internet based Database connectivity.
XML and related database technologies.
Multimedia databases.