Course code

INFO 12022

Key Facts

Database Management Systems

Current Students

To access your official course details for the year you started your Diploma, please visit the handbook

Course Overview

The purpose of this course is to develop an overall understanding of database management systems.  

Course Content

Introduction to database systems

Database system concepts and architecture, Three-tier architecture, and mapping

Data Modeling

Entity-Relationship (ER) model and Enhanced Entity-Relationship (EER) model

Relational model

Introduction to the relational model, Relational constraints, Normalization approach for relational database design (first, second, third, and BCNF normal forms), Foreign keys, Advantages and disadvantages of the normalization approach

Logical database design

ER to relational mapping and EER to relational mapping.

Data Manipulation using SQL

Constraints in SQL, Basic queries, Complex queries, insert, delete and update statements, database connectivity using MySQL. Queries and advanced concepts in MySQL.