CP5503 - Enterprise Database Systems - Oracle

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

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. CP5503 requires an advanced level of critical analysis and design at a postgraduate level, including design and development of custom user input/output interfaces.

Learning Outcomes

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

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 or equivalent previous education or experience
Inadmissible Subject Combinations:	CP2503

Availabilities
, , Study Period 23
Census Date 22-Dec-2006
Contact hours:	26 hours 13 hours 26 hours 13 hours
Assessment:	(40% - 60%); (% - 20%); (10%); (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
, , 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 13 hours
Assessment:	(40% - 60%); (% - 20%); (10%); (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
, , Study Period 2
Census Date 08-Sep-2006
Coord/Lect:	jc160865.
Contact hours:	26 hours 13 hours 26 hours 13 hours
Assessment:	(40% - 60%); (% - 20%); (10%); (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
, , Study Period 22
Census Date 08-Sep-2006
Contact hours:	26 hours 13 hours 26 hours 13 hours
Assessment:	(40% - 60%); (% - 20%); (10%); (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

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.