DATABASE MANAGEMENT SYSTEM (BCS403)

To Provide a strong foundation in database concepts, technology, and practice.

Download Syllabus PDF


Course Information

Course Code

BCS403

Credits

04

Total Hours

40 hours

Examination

Theory (3 hours)

Course Objectives

  • To Provide a strong foundation in database concepts, technology, and practice.
  • To Practice SQL programming through a variety of database problems.
  • To Understand the relational database design principles.

Course Modules

Exam Paper Scheme Of Valutation

DBMS BCS403

10 hours
Model Question Paper Solutions

Model Question Paper-1 with effect from 2022

10 hours
Module 1: Introduction to Databases

Topics: Introduction, Characteristics of database approach, Advantages of using the DBMS approach.

10 hours
Module 2: Relational Model

Topics: Relational Model Concepts, Relational Model Constraints and relational database schemas.

10 hours
Module 3: Normalization: Database Design Theory

Topics:Introduction to Normalization using Functional and Multivalued Dependencies.

10 hours
Module 4:SQL: Advanced Queries

Topics:More complex SQL retrieval queries, Specifying constraints as assertions and action triggers, Views in SQL. .

10 hours
Module 5: Concurrency Control in Databases

Topics: Two-phase locking techniques for Concurrency control, Concurrency control based on Timestamp ordering.

10 hours