Course Co-ordinator: Dr N Beacham

Pre-requisite(s): None.

Co-requisite(s): None.

Note(s): (i) Assistive technologies may be required for any student who is unable to use a standard keyboard/mouse/computer monitor. Any students wishing to discuss this further should contact the School Disability Co-ordinator.

The concepts of a database and database management. Database development. Illustrations. Entity-Relationship model. Database design: logical design and the relational model. Normalisation; different normal forms. Physical design; file organisation and access; indexing. Database administration. Query by Example and SQL. Query optimisation. Practical examples using MS Access.

Client-server model. Database servers. Database access from client applications. Web-based database access through server-side scripting. Practical examples using MS Access, My SQL, Php and JDBC.

A brief overview of key concepts in distributed, object -oriented, multimedia, spatial and geo-referenced database systems.

Four hours per week: 2 one-hour lectures, 1 two-hour practical.

1st Attempt: 1 two-hour written examination (75%); continuous assessment (25%). In order to pass this course, candidates must obtain a pass mark in the examination and in the overal combination of examination and continuous assessment.

Resit: 1 two-hour written examination (75%); continuous assessment mark carried forwards (25%). In order to pass this course, candidates must obtain a pass mark in the examination and in the overal combination of examination and continuous assessment.