CP5804 - Database Systems

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

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.