JCU Logo

James Cook University Subject Handbook - 2020

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

CP2404 - Database Modelling

Credit points:03
Year:2020
Student Contribution Band:Band 2
Administered by:College of Science and Engineering

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

  • describe and apply the techniques of normalisation
  • 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

Subject Assessment

  • Invigilated > End of semester exam - (50%)
  • Assignment 1 - (30%)
  • Practicals - (20%)

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

Census date:Thursday, 26 Mar 2020
Study Period Dates:Monday, 24 Feb 2020 to Friday, 19 Jun 2020
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.

JCU Brisbane, Study Period 21, Internal

Census date:Thursday, 09 Apr 2020
Study Period Dates:Monday, 16 Mar 2020 to Friday, 19 Jun 2020
Lecturer(s):
MS Puspa Pratiwi
MR Brett Vance
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, Study Period 22, Internal

Census date:Thursday, 06 Aug 2020
Study Period Dates:Monday, 13 Jul 2020 to Friday, 16 Oct 2020
Coordinator(s):
DR Kyungmi Joanne Lee
Lecturer(s):
MR Dion 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, Study Period 23, Internal

Census date:Thursday, 03 Dec 2020
Study Period Dates:Monday, 09 Nov 2020 to Friday, 19 Feb 2021
Lecturer(s):
MR Dion 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 Singapore, Study Period 52, Internal

Census date:Thursday, 06 Aug 2020
Study Period Dates:Monday, 13 Jul 2020 to Friday, 16 Oct 2020
Coordinator(s):
DR Insu Song
DR Kyungmi Joanne Lee
Lecturer(s):
MS Sithira Vadivel
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

Census date:Thursday, 26 Mar 2020
Study Period Dates:Monday, 24 Feb 2020 to Friday, 19 Jun 2020
Coordinator(s):
DR Kyungmi Joanne Lee
Lecturer(s):
MISS Elizabeth Forest
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

Census date:Thursday, 26 Mar 2020
Study Period Dates:Monday, 24 Feb 2020 to Friday, 19 Jun 2020
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.
  • 0 Hours - Other
Method of delivery:WWW - LearnJCU