CP1500 - Conceptual Modelling

Credit points:	03
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
Townsville, Internal, Study Period 2
Census Date 23-Aug-2012
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 (40%); quizzes or tests (20%); assignments (30%); practical work (10%).
Cairns, Internal, Study Period 2
Census Date 23-Aug-2012
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 (40%); quizzes or tests (20%); assignments (30%); practical work (10%).
JCU Singapore, Internal, Study Period 51
Census Date 22-Mar-2012
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 (40%); quizzes or tests (20%); assignments (30%); practical work (10%).
JCU Singapore, Internal, Study Period 53
Census Date 15-Nov-2012
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 (40%); quizzes or tests (20%); assignments (30%); practical work (10%).
Beijing UT, Internal, Study Period 68
Census Date 28-Jun-2012
Coordinator:	Dr Joanne Lee
Lecturer:	Assoc. Professor Ickjai 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 (40%); quizzes or tests (20%); assignments (30%); practical work (10%).
Beijing UT, Internal, Study Period 69
Census Date 13-Dec-2012
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 (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.