Image

[NMK20303] Database Management System

This subject focuses on the concept of database system and architecture. This includes data models, schemas and instances, and system environment. Students will be exposed to data modeling by using high-level conceptual data models for relational database design that includes Entity Relationship Diagram(ERD), Structured Query Language(SQL) and normalization and also covers database storage and management.

[NMK20303] Database Management System

Semester Plan

Week 1

Lab

Lab 1 : Software Installation and Configuration 1

Lecture

Introduction To Database

Week 2

Lab

Lab 1 : Software Installation and Configuration 2

Lecture

Overview of Database Languages and Architectures

Week 3

Lab

Lab 1 : Software Installation and Configuration 3

Lecture

The Database Relational Model

Week 4

Lab

Lab 2 : The Relational Database Model 1

Lecture

Standard Query Languages -1

Week 5

Lab

Lab 2 : The Relational Database Model 2

Lecture

Standard Query Languages -2

Week 6

Lab

Lab 3 : SQL Commands for Data Definition 1

Lecture

Standard Query Languages -3

Week 7

Lab

Lab 3 : SQL Commands for Data Definition 2

Lecture

The Normalization of Relational Model -1

Week 8

Lab

Lab 4 : SQL Commands for Data Manipulation 1

Lecture

The Normalization of Relational Model -2

Week 9

Lab

Lab 5 : SQL Commands for Data Manipulation 2

Lecture

The Normalization of Relational Model -3

Week 10

Lab

Lab 6 : Entity Relationship Diagram (ERD) 1

Lecture

The Normalization of Relational Model -4

Week 11

Lab

Lab 6 : Entity Relationship Diagram (ERD) 2

Lecture

The Normalization of Relational Model -5

Week 12

Lab

Mini Project

Lecture

Logical Database Design using Entity Relationship Diagram (ERD) -1

Week 13

Lab

Mini Project

Lecture

Mini Project

Week 14

Lab

Mini Project

Lecture

Mini Project

Final

[NMK20303] Database Management System Teaching Team

Team

Mohamed Elshaikh

Senior Lecturer