IT-405 RGPV B.Tech
Data Base Management System (DBMS)
Previous year papers and the official syllabus are free to read, no account needed.
Previous Year Papers
7 papers, latest Jun 2026
- IT-405 paper, Jun 2026
- IT-405 paper, Jun 2025
- IT-405 paper, Dec 2023
- IT-405 paper, Nov 2023
- IT-405 paper, Jun 2023
- IT-405 paper, Nov 2022
Syllabus, notes and important questions for IT-405
Syllabus units
Topics as the official RGPV syllabus lists them.
Unit 1 Basic Concepts 9 topics
- Introduction to DBMS
- File system versus DBMS comparison
- 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 and definition of the E‑R diagram
Unit 2 Relational Model 8 topics
- Structure of relational databases
- Domains and relations
- Relational algebra – fundamental operators and syntax
- Relational algebra queries
- Entity‑Relationship model basics and design process
- Constraints, keys, design issues
- E‑R diagrams, weak entity sets
- Extended E‑R features – generalization, specialization, aggregation
Unit 3 SQL 10 topics
- Data Definition Language (DDL) in SQL
- Update statements and views
- Data storage definitions
- Data retrieval queries
- Query processing and optimization overview
- Measures of query cost, selection, sorting, join operations
- Transformation of relational expressions
- Estimating statistics of expression results
- Evaluation plans
- Case studies of ORACLE and DB2
Unit 4 Relational Database Design 7 topics
- Functional dependencies – definition, trivial and non‑trivial FD
- Closure of FD set, irreducible set of FD
- Normalization – 1NF, 2NF, 3NF
- Decomposition preserving dependencies, lossless join
- Boyce‑Codd Normal Form (BCNF)
- Multivalued dependency, Fourth Normal Form (4NF)
- Join dependency, Fifth Normal Form (5NF)
Unit 5 Transaction Management and Concurrency Control 5 topics
- Transaction concepts, processing and recovery
- Concurrency control – lock management
- Specialized locking techniques
- Concurrency control without locking
- Protection and security aspects
Unit 6 Distributed Databases and Big Data 3 topics
- Distributed database concepts
- Basic concepts of object‑oriented database systems
- Overview of Big Data
Exam insights
Counted from 4 past IT-405 papers.
Marks asked per paper, by unit
-
Unit 1 Basic Concepts 21 marks
-
Unit 2 Relational Model 23 marks
-
Unit 3 SQL and Query Optimization 10 marks
-
Unit 4 Relational Database design 24 marks
-
Unit 5 Transaction, Concurrency Control and Advanced Topics 33 marks
Average marks of the questions from each unit in one paper. You answer only some of them, so the total is more than the paper’s maximum.
Asked again and again
-
Define a transaction and explain the ACID properties (Atomicity, Consistency, Isolation, Durability) with examples.
Asked 3 times: 2026, 2025, 2022
-
Draw and explain an Entity-Relationship (E-R) diagram for a database application (e.g., University with students, courses and faculty).
Asked 2 times: 2026, 2025
-
Explain relational database decomposition, its importance and process, including lossless and dependency-preserving decomposition with suitable examples.
Asked 2 times: 2026, 2025