COMP6240(2400)

Relational Databases

This course is an introduction to relational databases and the general skills for designing and using them. The topics include the relational data model, SQL, entity-relationship model, functional dependencies, (de-)normalisation, relational algebra, query processing and optimisation, database transactions and security. To deepen the understanding of relational databases, the current industry development of database systems such as NoSQL databases will be introduced at the end of this course. 本课程介绍关系数据库以及设计和使用它们的一般技能。主题包括关系数据模型、SQL、实体关系模型、功能依赖、(去)规格化、关系代数、查询处理和优化、数据库事务和安全性。为了加深对关系数据库的理解，在本课程的最后，我们将介绍数据库系统如NoSQL数据库的当前行业发展。