CP1500 - Introduction to Database Principles

Credit points:	03
Year:	2009
Student Contribution Band:	Band 2
Administered by:	School of Mathematics, Physics & IT (pre 2009)

The primary aims are to provide the student with an understanding of the importance of database technology in todays society and how they can use this technology to manage their own data requirements. The subject will include a detailed discussion of the database design and the relational database model.

Learning Outcomes

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

Availabilities
Townsville, Internal, Study Period 1
Census Date 27-Mar-2009
Coordinator:	Dr Carrie Lui
Lecturer:	Dr Jarrod Trevathan.
Contact hours:	39 hours lectures 26 hours tutorials 13 hours practicals
Assessment:	end of semester exam (55%); quizzes or tests (20%); assignments (25%).
Cairns, Internal, Study Period 1
Census Date 27-Mar-2009
Coord/Lect:	Dr Carrie Lui.
Contact hours:	39 hours lectures 26 hours tutorials 13 hours practicals
Assessment:	end of semester exam (55%); quizzes or tests (20%); assignments (25%).
JCU Singapore, Internal, Study Period 51
Census Date 27-Mar-2009
Coordinator:	Dr Carrie Lui
Contact hours:	39 hours lectures 26 hours tutorials 13 hours practicals
Assessment:	end of semester exam (55%); quizzes or tests (20%); assignments (25%).
JCU Singapore, Internal, Study Period 53
Census Date 20-Nov-2009
Coordinator:	Dr Carrie Lui
Contact hours:	39 hours lectures 26 hours tutorials 13 hours practicals
Assessment:	end of semester exam (55%); quizzes or tests (20%); assignments (25%).
Beijing UT, Internal, Study Period 61
Census Date 20-Feb-2009
Coordinator:	Dr Carrie Lui
Contact hours:	39 hours lectures 26 hours tutorials 13 hours practicals
Assessment:	end of semester exam (55%); quizzes or tests (20%); assignments (25%).
JCU Brisbane, Internal, Study Period 22
Census Date 14-Aug-2009
Coordinator:	Dr Carrie Lui
Contact hours:	39 hours lectures 26 hours tutorials 13 hours practicals
Assessment:	end of semester exam (55%); quizzes or tests (20%); assignments (25%).

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.