CY-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
8 papers, latest Jun 2025
- CY-405 paper, Jun 2025
- CY-405 paper, Dec 2024
- CY-405 paper, Jun 2024
- CY-405 paper, Dec 2023
- CY-405 paper, Nov 2023
- CY-405 paper, Jun 2023
Syllabus, notes and important questions for CY-405
Syllabus units
Topics as the official RGPV syllabus lists them.
Unit 1 Basic Concepts of Data and DBMS 11 topics
- Basic concepts of data and DBMS
- File organization and access methods
- Introduction to DBMS and differences with traditional file storage systems
- Characteristics of DBMS
- Data models, schemas, and instances
- DBMS architecture and components
- Data independence
- Entity‑Relationship (ER) model concepts
- Types of attributes
- Entity types and relationships
- Cardinalities, participation, roles, and constraints
Unit 2 Relational Data Model and SQL 8 topics
- Relational data model: domains, tuples, attributes, relations
- Keys and key types
- Integrity constraints
- Relational algebra operations: select, project, rename, join, union, intersection, difference, division, product
- Basic SQL queries and functions
- SQL constraints, joins, and nested queries
- Triggers, assertions, views, stored procedures
- PL/SQL
Unit 3 Normalization Theory and Database Methodologies 6 topics
- Normalization theory and database design methodologies
- Relation schemas and functional dependencies
- Axioms and inference rules for functional dependencies
- Normal forms: 1NF, 2NF, 3NF, BCNF
- Dependency preservation
- Lossless‑join decomposition
Unit 4 Transaction Processing and Concurrency Control 8 topics
- Transaction processing concepts and transaction states
- ACID properties
- Concurrency and recovery fundamentals
- Schedules, recoverability, and serializability
- Types of serializability and testing methods
- Concurrency control mechanisms: two‑phase locking, timestamp‑based control
- Deadlock management: avoidance, prevention, detection, resolution
- Recovery techniques: deferred update, immediate update, shadow paging, checkpoints
Unit 5 Storage Structures and Query Optimization 5 topics
- Storage structures and secondary storage devices
- Hashing and indexing structures: single‑level and multi‑level indices
- Query processing and optimization algorithms for select, project, join
- Complexity measures of query operations
- Case study of a contemporary DBMS
Exam insights
Counted from 6 past CY-405 papers.
Marks asked per paper, by unit
-
Unit 1 Basic Concepts of Data and DBMS 20 marks
-
Unit 2 Relational Data Model 24 marks
-
Unit 3 Normalization Theory and Database methodologies 21 marks
-
Unit 4 Transaction Processing 22 marks
-
Unit 5 Storage structures 22 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 DBMS and compare DBMS vs traditional file-based storage system, including drawbacks of file systems / benefits of DBMS.
Asked 3 times: 2025, 2024, 2022
-
Explain the different types of integrity constraints and rules to ensure data integrity and consistency in a DBMS.
Asked 2 times: 2025, 2024
-
Explain the different types of relational keys and the role of primary and candidate keys in ensuring data integrity and uniqueness
Asked 2 times: 2025, 2024