CP3020 - Advanced Database Management

Credit points:	03
Year:	2006
Student Contribution Band:	Band 2
Administered by:

The primary aim is to provide the student with an understanding of the issues involved in the design of database management systems. Topics covered include transaction management, recovery and concurrency, security and authorisation, distributed database systems and an examination of new database technologies.

Learning Outcomes

• have an understanding of different DBMS architectures including distributed databases, client/server systems and deductive databases;
• have some knowledge of new database developments including data warehouses and web database developments;
• understand the issues involved in the operation of a DBMS including transaction management, concurrency control and recovery.

Prerequisites:	CO3811 or CP1500 or CP2500
Inadmissible Subject Combinations:	CP5520

Availabilities
, , Study Period 1
Census Date 24-Mar-2006
Coordinator:	Assoc. Professor Hossein Ghodosi
Lecturer:	jc153806.
Contact hours:	26 hours 13 hours 26 hours
Assessment:	(60%); (20%); (20%).
, , Study Period 1
Census Date 24-Mar-2006
Coord/Lect:	Assoc. Professor Hossein Ghodosi.
Contact hours:	26 hours 13 hours 26 hours
Assessment:	(60%); (20%); (20%).
, , Study Period 21
Census Date 05-May-2006
Contact hours:	26 hours 13 hours 26 hours
Assessment:	(60%); (20%); (20%).
, , Study Period 22
Census Date 08-Sep-2006
Contact hours:	26 hours 13 hours 26 hours
Assessment:	(60%); (20%); (20%).
, , Study Period 23
Census Date 22-Dec-2006
Contact hours:	26 hours 13 hours 26 hours
Assessment:	(60%); (20%); (20%).
, , Study Period 32
Census Date 05-May-2006
Face to face teaching 27-Mar-2006 to 07-Jul-2006
Contact hours:	26 hours 13 hours 26 hours
Assessment:	(60%); (20%); (20%).
, , Study Period 33
Census Date 21-Jul-2006
Face to face teaching 24-Jul-2006 to 03-Nov-2006
Contact hours:	26 hours 13 hours 26 hours
Assessment:	(60%); (20%); (20%).
, , Study Period 34
Census Date 22-Dec-2006
Face to face teaching 20-Nov-2006 to 09-Mar-2007
Contact hours:	26 hours 13 hours 26 hours
Assessment:	(60%); (20%); (20%).

Note: Minor variations might occur due to the continuous Subject quality improvement process, and in case of minor variation(s) in assessment details, the Subject Outline represents the latest official information.