CP1500 - Introduction to Database Principles

Credit points:	03
Year:	2007
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 30-Mar-2007
Coordinator:	Dr Carrie Lui
Lecturer:	jc160394.
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 30-Mar-2007
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 30-Mar-2007
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 31-Aug-2007
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 14-Dec-2007
Contact hours:	39 hours lectures 26 hours tutorials 13 hours practicals
Assessment:	end of semester exam (55%); quizzes or tests (20%); assignments (25%).
ITTI Sydney, Internal, Study Period 21
Census Date 11-May-2007
Contact hours:	39 hours lectures 26 hours tutorials 13 hours practicals
Assessment:	end of semester exam (55%); quizzes or tests (20%); assignments (25%).
ITTI Sydney, Internal, Study Period 22
Census Date 31-Aug-2007
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 11-May-2007
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 31-Aug-2007
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 14-Dec-2007
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.