CP2503 - Enterprise Database Systems - Oracle

[Offered in odd-numbered years in Townsville, Cairns. ]

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

The primary aim of the subject is to provide the student with an understanding of the issues involved in the administration of an enterprise size database system. The subject uses Oracle as an example enterprise database system. Topics covered include security, backup and recovery, physical storage management, and software development for reporting and data entry.

Learning Outcomes

• explain the internal architecture of a database system;
• develop and administer a security policy for the database;
• design and implement a basic backup and recovery strategy;
• control and configure the physical storage requirements of a database and administer enterprise level database systems;
• develop software for reporting and data base entry for enterprise database systems.

Graduate Qualities

• The ability to think critically, to analyse and evaluate claims, evidence and arguments;
• The ability to select and use appropriate IT tools;
• The ability to access and employ online technologies effectively;
• A coherent and disciplined body of skills, knowledge, values and professional ethics in at least one discipline area;
• A commitment to lifelong learning and intellectual development.

Prerequisites:	CP1500
Inadmissible Subject Combinations:	CP5503

Availabilities
Townsville, Internal, Study Period 2
Census Date 28-Aug-2009
Coordinator:	Dr Carrie Lui
Lecturer:	Dr Jarrod Trevathan.
Contact hours:	26 hours lectures 13 hours tutorials 26 hours practicals
Assessment:	end of semester exam (40% - 60%); other exams (% - 20%); quizzes or tests (10%); assignments (20% - 50%).
Special Assessment Requirements:	A student must obtain at least an average of 40% over all invigilated components within a subject to pass the subject overall
Restrictions:	An enrolment quota applies to this offering.
Cairns, Internal, Study Period 2
Census Date 28-Aug-2009
Coord/Lect:	Dr Carrie Lui.
Contact hours:	26 hours lectures 13 hours tutorials 26 hours practicals
Assessment:	end of semester exam (40% - 60%); other exams (% - 20%); quizzes or tests (10%); assignments (20% - 50%).
Special Assessment Requirements:	A student must obtain at least an average of 40% over all invigilated components within a subject to pass the subject overall
Restrictions:	An enrolment quota applies to this offering.
JCU Singapore, Internal, Study Period 53
Census Date 20-Nov-2009
Coordinator:	Dr Carrie Lui
Contact hours:	26 hours lectures 13 hours tutorials 26 hours practicals
Assessment:	end of semester exam (40% - 60%); other exams (% - 20%); quizzes or tests (10%); assignments (20% - 50%).
Special Assessment Requirements:	A student must obtain at least an average of 40% over all invigilated components within a subject to pass the subject overall
Beijing UT, Internal, Study Period 61
Census Date 20-Feb-2009
Coord/Lect:	Dr Carrie Lui.
Contact hours:	26 hours lectures 13 hours tutorials 26 hours practicals
Assessment:	end of semester exam (40% - 60%); other exams (% - 20%); quizzes or tests (10%); assignments (20% - 50%).
Special Assessment Requirements:	A student must obtain at least an average of 40% over all invigilated components within a subject to pass the subject overall
Restrictions:	An enrolment quota applies to this offering.

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.