JCU Australia logo

Subject Search

CP2404 - Database Modelling

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

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

  • end of semester exam (50%)
  • assignment 1 (30%)
  • practicals (20%).
Inadmissible
Subject
Combinations: 		CP1500 CP5633

Availabilities
Townsville, Internal, Study Period 1
Census Date 26-Mar-2020
Coordinator: Dr Joanne Lee
Lecturer: Dr Mangalam Sankupellay.
Workload expectations:

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

  • 50 hours - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.
  • assessment and self-directed study

External, Study Period 1
Census Date 26-Mar-2020
Coord/Lect: Dr Joanne Lee.
Workload expectations:

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

  • 0 hours
  • assessment and self-directed study
Method of Delivery: WWW - LearnJCU

Cairns, Internal, Study Period 1
Census Date 26-Mar-2020
Coord/Lect: Dr Joanne Lee.
Workload expectations:

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

  • 50 hours - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.
  • assessment and self-directed study

JCU Singapore, Internal, Study Period 52
Census Date 06-Aug-2020
Workload expectations:

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

  • 50 hours - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.
  • assessment and self-directed study

JCU Brisbane, Internal, Study Period 21
Census Date 09-Apr-2020
Workload expectations:

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

  • 50 hours - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.
  • assessment and self-directed study

JCU Brisbane, Internal, Study Period 22
Census Date 06-Aug-2020
Workload expectations:

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

  • 50 hours - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.
  • assessment and self-directed study

JCU Brisbane, Internal, Study Period 23
Census Date 03-Dec-2020
Workload expectations:

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

  • 50 hours - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.
  • assessment and self-directed study

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.