CP3020 - Advanced Database Management

Credit points:	03
Year:	2008
Student Contribution Band:	Band 2
Administered by:	Discipline of Information Technology (pre 2009)

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
Townsville, Internal, Study Period 1
Census Date 04-Apr-2008
Coord/Lect:	Dr Hossein Ghodosi.
Contact hours:	26 hours lectures 13 hours tutorials 26 hours practicals
Assessment:	end of semester exam (60%); quizzes or tests (20%); assignments (20%).
Cairns, Internal, Study Period 1
Census Date 04-Apr-2008
Coordinator:	Dr Hossein Ghodosi
Lecturer:	Dr Kim Ku.
Contact hours:	26 hours lectures 13 hours tutorials 26 hours practicals
Assessment:	end of semester exam (60%); quizzes or tests (20%); assignments (20%).
JCU Singapore, Internal, Study Period 51
Census Date 28-Mar-2008
Coordinator:	Dr Hossein Ghodosi
Contact hours:	26 hours lectures 13 hours tutorials 26 hours practicals
Assessment:	end of semester exam (60%); quizzes or tests (20%); assignments (20%).
JCU Singapore, Internal, Study Period 52
Census Date 25-Jul-2008
Contact hours:	26 hours lectures 13 hours tutorials 26 hours practicals
Assessment:	end of semester exam (60%); quizzes or tests (20%); assignments (20%).
JCU Singapore, Internal, Study Period 53
Census Date 28-Nov-2008
Contact hours:	26 hours lectures 13 hours tutorials 26 hours practicals
Assessment:	end of semester exam (60%); quizzes or tests (20%); assignments (20%).
Beijing UT, Internal, Study Period 61
Census Date 15-Feb-2008
Contact hours:	26 hours lectures 13 hours tutorials 26 hours practicals
Assessment:	end of semester exam (60%); quizzes or tests (20%); assignments (20%).
Beijing UT, Internal, Study Period 63
Census Date 17-Oct-2008
Contact hours:	26 hours lectures 13 hours tutorials 26 hours practicals
Assessment:	end of semester exam (60%); quizzes or tests (20%); assignments (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.