CP1500 - Introduction to Database Principles

Credit points:	03
Year:	2006
Student Contribution Band:	Band 2
Administered by:

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
, , Study Period 1
Census Date 24-Mar-2006
Coordinator:	Ms Marianne Brown
Lecturer:	jc160865.
Contact hours:	39 hours 26 hours 13 hours
Assessment:	(55%); (20%); (25%).
, , Study Period 1
Census Date 24-Mar-2006
Coord/Lect:	Ms Marianne Brown.
Contact hours:	39 hours 26 hours 13 hours
Assessment:	(55%); (20%); (25%).
, , Study Period 21
Census Date 05-May-2006
Contact hours:	39 hours 26 hours 13 hours
Assessment:	(55%); (20%); (25%).
, , Study Period 23
Census Date 22-Dec-2006
Contact hours:	39 hours 26 hours 13 hours
Assessment:	(55%); (20%); (25%).
, , Study Period 22
Census Date 08-Sep-2006
Coordinator:	Ms Marianne Brown
Contact hours:	39 hours 26 hours 13 hours
Assessment:	(55%); (20%); (25%).
, , Study Period 32
Census Date 05-May-2006
Face to face teaching 27-Mar-2006 to 07-Jul-2006
Contact hours:	39 hours 26 hours 13 hours
Assessment:	(55%); (20%); (25%).
, , Study Period 33
Census Date 21-Jul-2006
Face to face teaching 24-Jul-2006 to 03-Nov-2006
Coordinator:	Ms Marianne Brown
Contact hours:	39 hours 26 hours 13 hours
Assessment:	(55%); (20%); (25%).
, , Study Period 34
Census Date 22-Dec-2006
Face to face teaching 20-Nov-2006 to 09-Mar-2007
Contact hours:	39 hours 26 hours 13 hours
Assessment:	(55%); (20%); (25%).
, , Study Period 21
Census Date 05-May-2006
Contact hours:	39 hours 26 hours 13 hours
Assessment:	(55%); (20%); (25%).
, , Study Period 22
Census Date 08-Sep-2006
Coordinator:	Ms Marianne Brown
Contact hours:	39 hours 26 hours 13 hours
Assessment:	(55%); (20%); (25%).
, , Study Period 23
Census Date 22-Dec-2006
Contact hours:	39 hours 26 hours 13 hours
Assessment:	(55%); (20%); (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.