James Cook University Subject Handbook - 2022
For subject information from 2025 and onwards, please visit the new JCU Course and Subject Handbook website.
CP5503 - Enterprise Database Systems - Oracle
| Credit points: | 03 |
| Year: | 2022 |
| Student Contribution Band: | Band 2 |
| Administered by: | College of Science and Engineering (pre 2023 PCS) |
Subject Description
- 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
Subject Assessment
- Written > Examination (centrally administered) - (45%) - Individual
- Written > Test/Quiz 1 - (10%) - Individual
- Assignment - (35%) - Individual
- Performance/Practice/Product > Practical assessment/practical skills demonstration - (10%) - Individual
Note that 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.
Assumed Knowledge: Students enrolling in this subject should have basic knowledge of relational database principles.
Inadmissible Subject Combinations: CP2503
Availabilities
JCU Brisbane, Trimester 1, Internal | |
| Census date: | Thursday, 10 Mar 2022 |
| Study Period Dates: | Monday, 14 Feb 2022 to Saturday, 14 May 2022 |
| Staff: | No staff allocated; see "This Subject In Other Years". |
| Workload expectations: | The student workload for this 3 credit point subject is approximately 130 hours.
|
JCU Singapore, Study Period 52, Internal Usually available in even-numbered years. | |
| Census date: | Thursday, 04 Aug 2022 |
| Study Period Dates: | Monday, 11 Jul 2022 to Friday, 14 Oct 2022 |
| Coordinator(s): | DR Euijoon Ahn |
| Lecturer(s): | MR Bahtee Eng |
| Workload expectations: | The student workload for this 3 credit point subject is approximately 130 hours.
|