CP1500 - Introduction to Database Principles

Credit points:	03
Year:	2008
Student Contribution Band:	Band 2
Administered by:	Discipline of Information Technology (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.

Inadmissible Subject Combinations:

CO1801 and CO3811 and CP2500 and CP3010 and CP5315

Availabilities
Townsville, Internal, Study Period 1
Census Date 04-Apr-2008
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 04-Apr-2008
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 28-Mar-2008
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 52
Census Date 25-Jul-2008
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 28-Nov-2008
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 63
Census Date 17-Oct-2008
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 21
Census Date 18-Apr-2008
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 15-Aug-2008
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 23
Census Date 12-Dec-2008
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.