Skip to main content

ModuleInformation

CSC2036

Database Systems

Course Contents

Module introduction:

  1. Relation Databases (structures of regional databases, SQL, advanced SQL). 
  2. Database Design (entity-relationship modelling, relational databases design).
  3. Database Querying (query processing, query optimization).
  4. Transaction Management (transactions, concurrency control, recovery systems)

Supplementary Notes

None

Learning Outcomes

Knowledge/understanding/application learning outcomes related to:

  1. Relation Databases (structures of relational databases, SQL, advanced SQL)
  2. Database Design (entity-relationship modelling, relational databases design)
  3. Database Querying (query processing, query optimisation)
  4. Transaction Management (transactions, concurreny control, recovery systems).

Skills

Analysis of problems, design of solutions, application of techniques, understanding results.