Individual practical assignment (30%) assessing Learning Outcomes 1 and 2
Individual Research Paper (70%) assessing Learning Outcome 1 and 3

Theory and models of database management systems.
Discussion of the relational and the extended relational model (ORDBMS). Discussion of the Object-Oriented approach and comparison with relational systems. Design methodologies for database systems, links with the systems analysis and design process Client-Server architectures, Web-database architectures. Passive and active database systems.

Data Dictionaries
The need for dictionaries and their use in database applications. Intelligent dictionary systems.

Database security and Database Administration
System security. Backup and recovery strategies. Handling concurrency, locking protocols. Role of a DBA within an organisation.

Distributed Databases
Centralisation versus decentralisation. Client/Server versus distributed database applications. Locking and transaction control (parallelism and serialisability). Recovery procedures.

Database Tuning
Query Optimisation. Database internals - controls and parameters. Query performance tools.

Data Warehousing and Data Mining, legacy systems and data marts. Metadata. Optimisation of the warehouse (use of bit-mapped indexes). Schema designs (stars and snowflakes). Multi-Dimensional Databases and On-line Analytical processing.

Object-Oriented Databases
Types of object, persistence, inheritance, methods, encapsulation, overriding and late-binding. Examples of applications research trends and issues.

Lectures, practical exercises, tutorials and software demonstrations will be used as appropriate to the material of the course.
(1:n)2 (1:20)2

None

Oracle
ASP

Database Systems Concepts, Korth and Silberschatz et. al., Osbourne McGraw Hill, 2001, ISBN: 0072283637
Database Systems: A Practical Approach to Design, Implementation and Management, 4th Edition, T M Connolly, C E Begg, Addison Wesley, 2004, ISBN: 0321210255