COMP 4754: Database Systems

This course is an elective for the Data-centric Computing Stream.

This course will be of interest to those students who wish to have an introduction to the problems involved in dealing with large amounts of data.

Prerequisites:  COMP 2004 or the former COMP 3725, and COMP 2007 or the former COMP 3754

Availability: This course is usually offered once per year, in Fall or Winter.

Course Objectives

To introduce students to database processing, database management systems and database design considerations. Additional topics covered include the theory and methodologies essential for the relational database design, implementation, manipulation, optimization and management.

Representative Workload
  • Assignments and Project 40%
  • In-class Exam 20%
  • Final Exam 40%
Representative Course Outline
  • Introduction to databases and database management systems
  • Entity relationship model
  • Database design
  • Requirement analysis
  • Conceptual modelling
  • Implementation design
  • Physical design
  • Modelling of data for various database models
  • Dependencies, normal forms and other database design considerations
  • Some sample query languages and query processing
  • Query optimization
  • Concurrency
  • Recovery
  • Security and integrity
  • Distributed databases

Page last updated May 24th 2021