CP2404 - Database Modelling

Credit points:	03
Year:	2018
Student Contribution Band:	Band 2
Administered by:	College of Business, Law & Governance

Introduced in this subject are 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 and applied. Through this subject students will develop skills in techniques and tools to model, design and implement a database system.

Learning Outcomes

• describe and apply the techniques of normalisation;
• apply a database design to a database management system;
• formulate queries using a database query language;
• examine database and database management systems, their features and rationale;
• develop a database model using the entity- relationship model.

Inadmissible Subject Combinations:

CP1500 CP5633

Availabilities
Townsville, Internal, Study Period 1
Census Date 22-Mar-2018
Coordinator:	Dr Joanne Lee
Lecturer:	Dr Dmitry Konovalov.
Contact hours:	50 hours - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.
Assessment:	end of semester exam (50%); assignment 1 (30%); practicals (20%).
External, Study Period 1
Census Date 22-Mar-2018
Coord/Lect:	Dr Joanne Lee.
Contact hours:	0 hours
Method of Delivery:	WWW - LearnJCU
Assessment:	end of semester exam (50%); assignment 1 (30%); practicals (20%).
Cairns, Internal, Study Period 1
Census Date 22-Mar-2018
Coord/Lect:	Dr Joanne Lee.
Contact hours:	50 hours - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.
Assessment:	end of semester exam (50%); assignment 1 (30%); practicals (20%).
JCU Singapore, Internal, Study Period 51
Census Date 05-Apr-2018
Coordinator:	Dr Joanne Lee
Contact hours:	50 hours - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.
Assessment:	end of semester exam (50%); assignment 1 (30%); practicals (20%).
JCU Singapore, Internal, Study Period 53
Census Date 29-Nov-2018
Coordinator:	Dr Joanne Lee
Contact hours:	50 hours - Combined Lectures; Tutorials/Workshops/ Practicals; Lecturer directed activities.
Assessment:	end of semester exam (50%); assignment 1 (30%); practicals (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.