JCU Australia logo

Subject Search

CP5503 - Enterprise Database Systems - Oracle

Credit points: 3
Year: 2019
Student Contribution Band: Band 2
Administered by: College of Science and Engineering

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.
Assumed
Knowledge:
Students enrolling in this subject should have basic knowledge of relational database principles.
Inadmissible
Subject
Combinations:
CP2503

Availabilities

JCU Singapore, Internal, Study Period 51
Census Date 11-Apr-2019
Coordinator: Assoc. Professor Hossein Ghodosi
Lecturer: Mrs Sarita Singh.
Workload expectations:

The student workload for this 3 credit point subject is approximately 130 hours.

  • 50 hours - Combined Lectures; Tutorials/Workshops/ Practicals (only the first hour of each practical is supervised)
  • assessment and self-directed study
Assessment: end of semester exam (45%); quizzes or tests (10%); assignments (35%); practical work (10%).

JCU Singapore, Internal, Study Period 53
Census Date 05-Dec-2019
Workload expectations:

The student workload for this 3 credit point subject is approximately 130 hours.

  • 50 hours - Combined Lectures; Tutorials/Workshops/ Practicals (only the first hour of each practical is supervised)
  • assessment and self-directed study
Assessment: end of semester exam (45%); quizzes or tests (10%); assignments (35%); practical work (10%).

JCU Brisbane, Internal, Study Period 22
Census Date 08-Aug-2019
Coordinator: Dr Mangalam Sankupellay
Lecturers: Dr Cue Nguyen, Mr Dion Nguyen.
Workload expectations:

The student workload for this 3 credit point subject is approximately 130 hours.

  • 26 hours lectures
  • 24 hours practicals - only the first hour of each practical is supervised.
  • assessment and self-directed study
Assessment: end of semester exam (45%); quizzes or tests (10%); assignments (35%); practical work (10%).

JCU Brisbane, Internal, Study Period 23
Census Date 05-Dec-2019
Coordinator: Dr Mangalam Sankupellay
Lecturer: Dr Cue Nguyen.
Workload expectations:

The student workload for this 3 credit point subject is approximately 130 hours.

  • 26 hours lectures
  • 24 hours practicals - only the first hour of each practical is supervised.
  • assessment and self-directed study
Assessment: end of semester exam (45%); quizzes or tests (10%); assignments (35%); practical work (10%).

JCU Brisbane, Internal, Study Period 21
Census Date 11-Apr-2019
Coordinator: Assoc. Professor Hossein Ghodosi
Lecturer: Dr Cue Nguyen.
Workload expectations:

The student workload for this 3 credit point subject is approximately 130 hours.

  • 26 hours lectures
  • 24 hours practicals - only the first hour of each practical is supervised.
  • assessment and self-directed study
Assessment: end of semester exam (45%); quizzes or tests (10%); assignments (35%); practical work (10%).

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.