ENCT301

Database Management System

3credits
150total marks

Course objective

The objective of this course is to provide a comprehensive understanding of the principles and practices involved in the design and implementation of database systems, enabling students to develop data models and perform data modification, processing and management efficiently, including advanced concepts such as object-oriented databases, data warehousing and big data management.

Syllabus at a glance

  1. 1Introduction
  2. 2Data Models
  3. 3Relational Query Languages
  4. 4Database Constraints and Normalization
  5. 5Query Processing and Optimization
  6. 6File Structure and Hashing
  7. 7Transaction Processing and Concurrency Control
  8. 8Crash Recovery
  9. 9Advanced Database Concepts
Read the full syllabus