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.