Database Management System

Database Management System

Course Objectives:

The course aims:

  1.  To learn the basics and understand the need of database management system.
  2. To construct conceptual data model for real world applications
  3. To Build Relational Model from ER/EER.
  4. To introduce the concept of SQL to store and retrieve data efficiently.
  5. To demonstrate notions of normalization for database design.
  6. To understand the concepts of transaction processing- concurrency control & recovery procedures.
Course Outcomes:

On successful completion, of course, learner/student will be able to:

  1. Identify the need of Database Management System. L1, L2
  2. Design conceptual model for real life applications. L6
  3. Create Relational Model for real life applications L6
  4. Formulate query using SQL commands. L3
  5. Apply the concept of normalization to relational database design. L3
  6. Demonstrate the concept of transaction, concurrency and recovery. L2