JCU Australia logo

Subject Search

CP1500 - Conceptual Modelling

Credit points: 3
Year: 2012
Student Contribution Band: Band 2
Administered by: School of Business

The subject will provide an introduction to 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. Techniques and tools to model, design, and implement a database system will also be presented.

Learning Outcomes

  • implement a database design using a relational database management system;
  • describe the relational database model, its features and their rationale;
  • model a database using the entity-relationship model and understand the database development process;
  • use the techniques of normalisation and describe their basis;
  • formulate database queries in SQL.

Graduate Qualities

  • The ability to deploy critically evaluated information to practical ends;
  • An understanding of the economic, legal, ethical, social and cultural issues involved in the use of information;
  • The ability to select and organise information and to communicate it accurately, cogently, coherently, creatively and ethically.

Availabilities

Beijing UT, Study Period 68, Internal
Census Date 28-Jun-2012
Coordinator: Dr Kyungmi Joanne Lee
Lecturer: Professor Ickjai Lee.
Workload expectations:
  • 26 hours lectures
  • 12 hours tutorials
  • 24 hours practicals - only the first hour of each practical is supervised
Assessment: end of semester exam (40%); quizzes or tests (20%); assignments (30%); practical work (10%).

Beijing UT, Study Period 69, Internal
Census Date 13-Dec-2012
Coordinator: Dr Kyungmi Joanne Lee
Workload expectations:
  • 26 hours lectures
  • 12 hours tutorials
  • 24 hours practicals - only the first hour of each practical is supervised
Assessment: end of semester exam (40%); quizzes or tests (20%); assignments (30%); practical work (10%).

Cairns, Study Period 2, Internal
Census Date 23-Aug-2012
Coord/Lect: Dr Kyungmi Joanne Lee.
Workload expectations:
  • 26 hours lectures
  • 12 hours tutorials
  • 24 hours practicals - only the first hour of each practical is supervised
Assessment: end of semester exam (40%); quizzes or tests (20%); assignments (30%); practical work (10%).

JCU Singapore, Study Period 51, Internal
Census Date 22-Mar-2012
Coordinator: Dr Kyungmi Joanne Lee
Workload expectations:
  • 26 hours lectures
  • 12 hours tutorials
  • 24 hours practicals - only the first hour of each practical is supervised
Assessment: end of semester exam (40%); quizzes or tests (20%); assignments (30%); practical work (10%).

JCU Singapore, Study Period 53, Internal
Census Date 15-Nov-2012
Coordinator: Dr Kyungmi Joanne Lee
Workload expectations:
  • 26 hours lectures
  • 12 hours tutorials
  • 24 hours practicals - only the first hour of each practical is supervised
Assessment: end of semester exam (40%); quizzes or tests (20%); assignments (30%); practical work (10%).

Townsville, Study Period 2, Internal
Census Date 23-Aug-2012
Coordinator: Dr Kyungmi Joanne Lee
Lecturer: Assoc. Professor Trina Myers.
Workload expectations:
  • 26 hours lectures
  • 12 hours tutorials
  • 24 hours practicals - only the first hour of each practical is supervised
Assessment: end of semester exam (40%); quizzes or tests (20%); assignments (30%); 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.