Database Management System – Syllabus

Database Management System – Syllabus

  • Introduction to Databases:
    • Lesson 1. Definition and characteristics of databases.
      01 Hrs.
    • Lesson 2. Advantages over traditional file systems.
      01 Hrs.
    • Lesson 3. Database users and their roles.
      01 Hrs.
    • Lesson 4. Database environment and architecture.
      01 Hrs.
    • Lesson 5. Role of Database Administrator (DBA).
      01 Hrs.
  • Data Models and Architecture:
    • Lesson 1. Schemas and instances.
      02 Hrs.
    • Lesson 2. DBMS architecture.
      01 Hrs.
    • Lesson 3. Three-level architecture (ANSI-SPARC).
      02 Hrs.
    • Lesson 4. Data independence.
      02 Hrs.
  • Entity-Relationship (E-R) Modeling:
    • Lesson 1. Entities, attributes, and relationships.
      04 Hrs.
    • Lesson 2. E-R diagrams and design.
      04 Hrs.
    • Lesson 3. Mapping E-R models to relational schemas.
      02 Hrs.
  • Relational Model:
    • Lesson 1. Structure of relational databases.
      02 Hrs.
    • Lesson 2. Relational algebra and calculus.
      02 Hrs.
    • Lesson 3. Integrity constraints and keys.
      02 Hrs.
  • Structured Query Language (SQL)
    • Lesson 1. Data Definition Language (DDL).
      04 Hrs.
    • Lesson 2. Data Manipulation Language (DML).
      04 Hrs.
    • Lesson 3. Data Control Language (DCL).
      01Hrs.
    • Lesson 3. Joins, subqueries, and views.
      02 Hrs.
  • Normalization:
    • Lesson 1. Functional dependencies.
      02 Hrs.
    • Lesson 2. Normal forms (1NF to 3NF, BCNF).
      02 Hrs.
    • Lesson 3. Decomposition and lossless join.
      02 Hrs.
  • Transaction Management:
    • Lesson 1. ACID properties.
      02 Hrs.
    • Lesson 2. Transaction states and concurrency control.
      02 Hrs.
    • Lesson 3. Deadlock and recovery techniques.
      02 Hrs.
  • Indexing and Hashing:
    • Lesson 1. Types of indexing (single-level, multi-level).
      02 Hrs.
    • Lesson 2. Hashing techniques and collision resolution.
      02 Hrs.
  • File Organization:
    • Lesson 1. Sequential, indexed, and hashed file organizations.
      02 Hrs.
    • Lesson 2. File access methods.
      02 Hrs.
  • Database Security and Authorization:
    • Lesson 1. Authentication and access control.
      02 Hrs.
    • Lesson 2. Security models and policies.
      02 Hrs.