CP1500 - Conceptual Modelling

Credit points:	03
Year:	2011
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 25-Aug-2011
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 (50%); quizzes or tests (10%); practical work (10%); assignments (10%); assignment 2 - database implementation and querying (20%).
Cairns, Internal, Study Period 2
Census Date 25-Aug-2011
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 (50%); quizzes or tests (10%); practical work (10%); assignments (10%); assignment 2 - database implementation and querying (20%).
JCU Singapore, Internal, Study Period 51
Census Date 24-Mar-2011
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 (50%); quizzes or tests (10%); practical work (10%); assignments (10%); assignment 2 - database implementation and querying (20%).
JCU Singapore, Internal, Study Period 53
Census Date 17-Nov-2011
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 (50%); quizzes or tests (10%); practical work (10%); assignments (10%); assignment 2 - database implementation and querying (20%).
JCU Singapore, Internal, Study Period 52
Census Date 21-Jul-2011
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 (50%); quizzes or tests (10%); practical work (10%); assignments (10%); assignment 2 - database implementation and querying (20%).
Beijing UT, Internal, Study Period 68
Census Date 30-Jun-2011
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 (50%); quizzes or tests (10%); practical work (10%); assignments (10%); assignment 2 - database implementation and querying (20%).
Beijing UT, Internal, Study Period 69
Census Date 15-Dec-2011
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 (50%); quizzes or tests (10%); practical work (10%); assignments (10%); assignment 2 - database implementation and querying (20%).

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.