AI-Powered Learning Platform

Subject Syllabus

CB-305 - Database Management Systems

CSBS · Semester 3

Course Modules

Learn topic-wise with Hyper AI and revise using mapped PYQs.

Introduction to Database Hierarchical, Network and Relational Models Data Abstraction, Data Independence Data Definition Language (DDL)Data Manipulation Language (DML)

Entity-relationship model Network model Relational and object oriented data models Integrity constraints Data manipulation operations

Relational algebra Tuple and domain relational calculus SQL3, DDL and DML constructs Open source and Commercial DBMS - MYSQL, ORACLE, DB2, SQL server Domain and data dependency, Armstrong's axioms Functional Dependencies, Normal forms Dependency preservation, Lossless design

Evaluation of relational algebra expressions Query equivalence Join strategies Query optimization algorithms Indices, B-trees, Hashing

Concurrency control, ACID property Serializability of scheduling Locking and timestamp based schedulers Multi-version and optimistic Concurrency Control schemes Database recovery Authentication, Authorization and access control DAC, MAC and RBAC models Intrusion detection, SQL injection Object oriented and object relational databases Logical databases, Web databases, Distributed databases Data warehousing and data mining