AI-Powered Learning Platform

Subject Syllabus

CSIT-405 – Database Management System (DBMS)

CSIT • SEMESTER-4

Rajiv Gandhi Proudyogiki Vishwavidyalaya, Bhopal

Course Modules

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

Introduction to DBMS, File system vs DBMS, Advantages of database systems Database System architecture, Data models, Schemas and instances, Data independence Functions of DBA and designer Entities and attributes, Entity types, Key attributes, Relationships, Defining the E-R diagram of database

Structure of relational databases, Domains, Tuples, Attributes, Relations Keys and types of keys, Integrity Constraints Relational Algebra: Queries using Select operation, project operation, renaming, joins, union, intersection, difference, division, and product etc.SQL –basic SQL queries, functions, constraints, joins and nested queries Triggers, assertions, views and stored procedures and PL/SQL

Data definition in SQL, update statements and views in SQL: Data storage and definitions, Data retrieval queries and update statements Query Processing & Query Optimization: Overview, measures of query cost, selection operation, sorting, join, evaluation of expressions, transformation of relational expressions, estimating statistics of expression results, evaluation plans Case Study of ORACLE and DB2

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, lossless join BCNF Multi-valued dependency, 4NF Join dependency and 5NF

Introduction of transaction, transaction processing and recovery Concurrency control: Lock management, specialized locking techniques, concurrency control without locking Protection and Security Introduction to: Distributed databases Basic concepts of object oriented data base system