-ORACLE relational database management system, students will require access to the SQL*PLUS and Developer 2000 products.
-sql server; MySQL
- The Library,
- ITS and Computing labs
- NetBeans

This module will develop knowledge of current DBMS support for Information Systems. You will acquire the ability to make informed DBMS selection from a critical appreciation of key database issues. Theoretical and contextual material will be presented in lectures and tutorials. You will carry out academic research to complement the subject matter some of which will be integrated into the assessment. You will be provided with practical exercises to enable you to see how the theories are put into practice.
1 lecture and 1 practical per week; (1:n)1 (1:20)1.

Advanced database architectures, N-Tier, Grid Computing, Distributed Databases.
Data Models, Relational and Object-Relational technologies, query languages including advanced SQL and Object SQL;
Advanced Design and design issues; database development and performance.
Current trends in Database development, including knowledge management, web and mobile databases; database issues for complex data including forensic and biometric data.

A coursework weighted at 100% made up of:-

1) Assignment weighted at 70% (Learning Outcomes 1, 2 and 3)
2) Management Style Report - 1500 words weighted at 30% (Learning Outcome 4)

Prior study of Database and Systems or equivalent.

Date C J, Database System, 8th Edition Vol 1 Addison-Wesley 2004, ISBN: 0321189566
Connolly T, Begg C, Database Systems, 4th Edition, Addison Wesley, 2005, ISBN: 0201342871
Various internet based materials