DBMS Syllabus

DBMS Syllabus

Database Management System (4040233101)

Unit-01 Introductory Concept of DBMS (21%)

  • Introduction and applications of DBMS
  • Purpose of database
  • Data Independence
  • Database System architecture-levels
  • Mappings
  • Database
  • users and DBA.

Unit-02 Relational Model (35%)

  • Relational Model:
    • Structure of relational databases
    • Domains
    • Relations
    • Relational algebra – fundamental operators and syntax, relational algebra queries, tuple relational calculus
  • Entity-Relationship model:
    • Basic concepts, Design process, constraints, Keys, Design issues, E-R diagrams, weak entity sets, extended E-R features – generalization, specialization, aggregation, reduction to E-R database schema

Unit-03 Relational Database Design (22%)

  • Functional Dependency – definition, trivial and non-trivial FD, closure of FD set, closure of attributes, irreducible set of FD
  • Normalization – 1NF, 2NF, 3NF
  • Decomposition using FD- dependency preservation
  • BCNF
  • Multivalued dependency
  • 4NF
  • Join dependency
  • 5NF

Unit-04 SQL Concepts (22%)

Basics of SQL:

  • DDL (Data Definition Language)
  • DML (Data Manipulation Language)
  • DCL (Data Control Language)

Structure:

  • Creation
  • Alteration

Defining Constraints:

  • Primary key
  • Foreign key
  • Unique
  • Not null
  • Check
  • IN operator

Functions:

  • Aggregate functions
  • Built-in functions:
    • Numeric functions
    • Date functions
    • String functions

Set Operations:

  • Sub-queries
  • Correlated subqueries

Clauses and Operators:

  • Use of GROUP BY
  • Use of HAVING
  • Use of ORDER BY

Join and Its Types:

  • Inner join
  • Outer join (left, right, full)
  • Cross join

Made By SOU Student for SOU Students