CP1500 - Conceptual Modelling

Credit points:	03
Year:	2014
Student Contribution Band:	Band 2
Administered by:	School of Business (pre 2015)

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.

Inadmissible Subject Combinations:

CP5633

Availabilities
Townsville, Internal, Study Period 2
Census Date 28-Aug-2014
Coordinator:	Dr Joanne Lee
Lecturer:	Dr Trina Myers.
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%).
Cairns, Internal, Study Period 2
Census Date 28-Aug-2014
Coord/Lect:	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 51
Census Date 20-Mar-2014
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 17-Jul-2014
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 13-Nov-2014
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%).
Restrictions:	An enrolment quota applies to this offering.
Beijing UT, Internal, Study Period 68
Census Date 29-May-2014
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 11-Dec-2014
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.