CP5503 - Enterprise Database Systems - Oracle
| Credit points: | 03 |
| Year: | 2010 |
| Student Contribution Band: | Band 2 |
| Administered by: | School of Business |
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;
- analyse, design and implement SME database systems and software;
- design and implement a basic backup and recovery strategy and develop software for reporting and database entry for enterprise database systems.
Graduate Qualities
- The ability to appraise information critically;
- The ability to think laterally and be original;
- The ability to conceptualise problems;
- The ability to conceptualise and evaluate a range of potential solutions to relevant problems;
- The potential to lead and contribute to projects effectively and efficiently;
- The ability to conduct their research in an ethical manner;
- The ability to make constructive contributions to project teams or collegial activities;
- The potential to resolve conflicts.
| Assumed Knowledge: | Students enrolling in this subject should have basic knowledge of relational database principles. |
| Inadmissible Subject Combinations: | CP2503 |
Availabilities | |
| Townsville, Block, Study Period 6 | |
| Census Date 24-Jun-2010 | |
| Face to face teaching 18-Jun-2010 to 04-Jul-2010 (3 weekends 18-20/6; 25-27/6 and 2-4/7: friday nights 6-9pm, Saturday and Sunday 9am - 5pm) | |
| Coordinator: | Dr Joanne Lee |
| Lecturer: | Mr Jayant Varma. |
| Contact hours: |
|
| Assessment: | end of semester exam (50% - 60%); assignments (20% - 40%); (10% - 20%). |
| 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 |
| Cairns, Block, Study Period 6 | |
| Census Date 24-Jun-2010 | |
| Face to face teaching 21-Jun-2010 to 09-Jul-2010 (Face to face dates are from Monday to Friday from 21 June to 2 July, 2010 from 9am to 5pm.) | |
| Lecturers: | Dr Kim Ku, Dr Joanne Lee. |
| Contact hours: |
|
| Assessment: | end of semester exam (50% - 60%); assignments (20% - 40%); (10% - 20%). |
| 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 |
| JCU Singapore, Internal, Study Period 51 | |
| Census Date 25-Mar-2010 | |
| Coordinator: | Dr Joanne Lee |
| Contact hours: |
|
| Assessment: | end of semester exam (40% - 60%); assignments (20% - 40%); (10% - 20%). |
| 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 |
| JCU Singapore, Internal, Study Period 53 | |
| Census Date 18-Nov-2010 | |
| Coordinator: | Dr Carrie Lui |
| Contact hours: |
|
| Assessment: | end of semester exam (40% - 60%); assignments (20% - 40%); (10% - 20%). |
| 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 |
| JCU Brisbane, Internal, Study Period 22 | |
| Census Date 12-Aug-2010 | |
| Coordinator: | Dr Carrie Lui |
| Contact hours: |
|
| Assessment: | end of semester exam (40% - 60%); assignments (20% - 40%); (10% - 20%). |
| 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.