James Cook University Subject Handbook - 2024

CP5804 - Database Systems

Subject Description

The subject will provide an introduction to the principles and concepts of database systems and their importance in data science. 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 using SQL.

Learning Outcomes

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

Subject Assessment

• Written > Test/Quiz 1 - (35%) - Individual
• Assignments - (40%) - Individual
• Performance/Practice/Product > Practical assessment/practical skills demonstration - (25%) - Individual

Note that 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.

Inadmissible Subject Combinations:  CP1500 CP2404 CP5633

Availabilities