CP1500 - Conceptual Modelling

Credit points:	03
Year:	2015
Student Contribution Band:	Band 2
Administered by:	College of Business, Law & Governance

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.

Inadmissible Subject Combinations:

CP2404 CP5633

Availabilities
Townsville, Internal, Study Period 1
Census Date 26-Mar-2015
Coordinator:	Dr Joanne Lee
Contact hours:	50 hours - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities
Assessment:	end of semester exam (45%); assignments (30%); test (15%); practical assessment items (10%).
Cairns, Internal, Study Period 1
Census Date 26-Mar-2015
Coord/Lect:	Dr Joanne Lee.
Contact hours:	50 hours - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.
Assessment:	end of semester exam (45%); assignments (30%); test (15%); practical assessment items (10%).
JCU Singapore, Internal, Study Period 51
Census Date 09-Apr-2015
Coordinator:	Dr Joanne Lee
Contact hours:	26 hours lectures 12 hours tutorials 24 hours practicals - only the first hour of each practical is supervised
Assessment:	end of semester exam (35%); quizzes or tests (15%); assignments (40%); practical work (10%).
JCU Singapore, Internal, Study Period 52
Census Date 30-Jul-2015
Coordinator:	Dr Joanne Lee
Contact hours:	26 hours lectures 12 hours tutorials 24 hours practicals - only the first hour of each practical is supervised
Assessment:	end of semester exam (35%); quizzes or tests (15%); assignments (40%); practical work (10%).
JCU Singapore, Internal, Study Period 53
Census Date 26-Nov-2015
Coordinator:	Dr Joanne Lee
Contact hours:	26 hours lectures 12 hours tutorials 24 hours practicals - only the first hour of each practical is supervised
Assessment:	end of semester exam (35%); quizzes or tests (15%); assignments (40%); practical work (10%).
Beijing UT, Internal, Study Period 68
Census Date 04-Jun-2015
Coordinator:	Dr Joanne Lee
Contact hours:	26 hours lectures 12 hours tutorials 24 hours practicals - only the first hour of each practical is supervised
Assessment:	end of semester exam (35%); quizzes or tests (15%); assignments (40%); practical work (10%).
Beijing UT, Internal, Study Period 69
Census Date 10-Dec-2015
Coordinator:	Dr Joanne Lee
Contact hours:	26 hours lectures 12 hours tutorials 24 hours practicals - only the first hour of each practical is supervised
Assessment:	end of semester exam (35%); quizzes or tests (15%); assignments (40%); 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.