Critically assess the main DBMS systems in commercial use (sql-server, oracle, MySql, DB2)
Database administration and the position of the database administrator
Data Dictionaries and their role in operational systems
Client/Server systems and distributed database technologies
Web and mobile database interfaces
XML and related technologies
Server side programming
Advanced Sql
Security and validation techniques, including site security, backups, data recovery, system recovery, Concurrency control
Performance issues; Database tuning and query optimisation techniques and facilities, clustering, indexing diagnostic tools
Decision support systems ?olap; data-warehousing, data mining

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.
2 lectures and 1 practical per week; (1:n)2 (1:20)1.

-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,

Prior study of Database and web database 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

Group Assignment weighted at 50%. Learning outcomes: (2,3)
Time constrained examination with a multi choice questionnaire element and short answer section weighted at 50%. 2 hrs Learning outcomes: (1,2,4)