James Cook University Subject Handbook - 2022

For subject information from 2025 and onwards, please visit the new JCU Course and Subject Handbook website.

CP2404 - Database Modelling

Credit points:	03
Year:	2022
Student Contribution Band:	Band 2
Administered by:	College of Science and Engineering (pre 2023 PCS)

Subject Description

Introduced in this subject are the principles and concepts of database systems and their importance in today's society. The relational model and various competing models for database and a database query language are introduced and applied. Through this subject students will develop skills in techniques and tools to model, design and implement a database system.

Learning Outcomes

apply a database design to a database management system
formulate queries using a database query language
examine database and database management systems, their features and rationale
develop a database model using the entity- relationship model
describe and apply the techniques of normalisation

Subject Assessment

Assignments - (40%) - Individual
Performance/Practice/Product > Practical assessment/practical skills demonstration - (30%) - Individual
Written > Examination (centrally administered) - (30%) - 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.

Inadmissible Subject Combinations: CP1500 CP5633

Availabilities

Cairns, Study Period 1, Internal Not expected to be available after this year.
Census date:	Thursday, 24 Mar 2022
Study Period Dates:	Monday, 21 Feb 2022 to Friday, 17 Jun 2022
Coordinator(s):	DR Kyungmi Joanne Lee
Lecturer(s):	DR Kyungmi Joanne Lee
Workload expectations:	The student workload for this 3 credit point subject is approximately 130 hours. 50 Hours - Other - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.

Cairns, Trimester 3, Internal
Census date:	Thursday, 06 Oct 2022
Study Period Dates:	Monday, 12 Sep 2022 to Saturday, 10 Dec 2022
Coordinator(s):	DR Kyungmi Joanne Lee
Lecturer(s):	DR Kyungmi Joanne Lee DR Zhigang Lu
Workload expectations:	The student workload for this 3 credit point subject is approximately 130 hours. 50 Hours - Other - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.

JCU Brisbane, Trimester 1, Internal
Census date:	Thursday, 10 Mar 2022
Study Period Dates:	Monday, 14 Feb 2022 to Saturday, 14 May 2022
Coordinator(s):	DR Kyungmi Joanne Lee
Lecturer(s):	DR Kyungmi Joanne Lee DR Cue Nguyen
Workload expectations:	The student workload for this 3 credit point subject is approximately 130 hours. 50 Hours - Other - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.

JCU Brisbane, Trimester 2, Internal
Census date:	Thursday, 23 Jun 2022
Study Period Dates:	Monday, 30 May 2022 to Saturday, 27 Aug 2022
Coordinator(s):	DR Kyungmi Joanne Lee
Lecturer(s):	DR Kyungmi Joanne Lee DR Cue Nguyen
Workload expectations:	The student workload for this 3 credit point subject is approximately 130 hours. 50 Hours - Other - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.

JCU Brisbane, Trimester 3, Internal
Census date:	Thursday, 06 Oct 2022
Study Period Dates:	Monday, 12 Sep 2022 to Saturday, 10 Dec 2022
Coordinator(s):	DR Kyungmi Joanne Lee
Lecturer(s):	DR Kyungmi Joanne Lee DR Cue Nguyen DR Zhigang Lu
Workload expectations:	The student workload for this 3 credit point subject is approximately 130 hours. 50 Hours - Other - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.

JCU Singapore, Study Period 52, Internal
Census date:	Thursday, 04 Aug 2022
Study Period Dates:	Monday, 11 Jul 2022 to Friday, 14 Oct 2022
Coordinator(s):	DR Kyungmi Joanne Lee
Lecturer(s):	MS Mala Selvaraj
Workload expectations:	The student workload for this 3 credit point subject is approximately 130 hours. 50 Hours - Other - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.

Townsville, Study Period 1, Internal Not expected to be available after this year.
Census date:	Thursday, 24 Mar 2022
Study Period Dates:	Monday, 21 Feb 2022 to Friday, 17 Jun 2022
Coordinator(s):	DR Kyungmi Joanne Lee
Lecturer(s):	Assoc. Professor Hossein Ghodosi
Workload expectations:	The student workload for this 3 credit point subject is approximately 130 hours. 50 Hours - Other - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.

Townsville, Trimester 3, Internal
Census date:	Thursday, 06 Oct 2022
Study Period Dates:	Monday, 12 Sep 2022 to Saturday, 10 Dec 2022
Coordinator(s):	DR Kyungmi Joanne Lee
Lecturer(s):	Assoc. Professor Hossein Ghodosi DR Zhigang Lu
Workload expectations:	The student workload for this 3 credit point subject is approximately 130 hours. 50 Hours - Other - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.

Study Period 1, External Not expected to be available after this year.
Census date:	Thursday, 24 Mar 2022
Study Period Dates:	Monday, 21 Feb 2022 to Friday, 17 Jun 2022
Coordinator(s):	DR Kyungmi Joanne Lee
Lecturer(s):	DR Kyungmi Joanne Lee
Workload expectations:	The student workload for this 3 credit point subject is approximately 130 hours. 50 Hours - Other - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.
Method of delivery:	WWW - LearnJCU

Trimester 3, External
Census date:	Thursday, 06 Oct 2022
Study Period Dates:	Monday, 12 Sep 2022 to Saturday, 10 Dec 2022
Coordinator(s):	DR Kyungmi Joanne Lee
Lecturer(s):	DR Zhigang Lu
Workload expectations:	The student workload for this 3 credit point subject is approximately 130 hours. 50 Hours - Other - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.
Method of delivery:	Online - JCU