Skip to content
CampusPrep

AL-502 RGPV B.Tech

Database Management Systems (DBMS)

Previous year papers and the official syllabus are free to read, no account needed.

Previous Year Papers

5 papers, latest Dec 2025

Free
See all 5 papers

Syllabus, notes and important questions for AL-502

Syllabus units

Topics as the official RGPV syllabus lists them.

Unit 1 DBMS Concepts and Architecture 16 topics
  • Introduction to DBMS concepts and architecture
  • Database approach vs. traditional file accessing approach
  • Advantages of database systems
  • Data models, schemas and instances
  • Data independence
  • Database languages and interfaces
  • Overall database structure
  • Functions of DBA and designer
  • Entity‑Relationship (ER) data model: entities, attributes, entity types
  • Defining the ER diagram
  • Generalization, aggregation and specialization in ER modeling
  • Transforming ER diagram into relational tables
  • Other data models: object‑oriented, network, relational
  • Comparison of data‑model types
  • Storage structures: secondary storage devices
  • Hashing and indexing structures: single‑level and multilevel indices
Unit 1 notes
Unit 2 Relational Data Models 11 topics
  • Relational data model fundamentals: domains, tuples, attributes, relations
  • Characteristics of relations and keys (primary, candidate, foreign)
  • Relational database schemas and integrity constraints
  • Referential integrity, intension and extension
  • SQL Data Definition Language (DDL) and Data Manipulation Language (DML)
  • Integrity constraints in SQL
  • Complex SQL queries and various join operations
  • Indexing and triggers in relational databases
  • Assertions in SQL
  • Relational algebra operations: select, project, join, division, outer union
  • Relational calculus: tuple‑oriented and domain‑oriented forms
Unit 2 notes
Unit 3 Database Design and Query Optimization 10 topics
  • Normalization theory and techniques
  • Normal forms: 1NF, 2NF, 3NF, BCNF
  • Functional dependencies and decomposition
  • Dependency preservation and lossless‑join decomposition
  • Handling null‑valued and dangling tuples
  • Multivalued dependencies
  • Introduction to query optimization
  • Steps of query optimization
  • Algorithms for implementing select, project, and join operations
  • Heuristic‑based and cost‑estimation‑based optimization methods
Unit 3 notes
Unit 4 Transaction Processing and Concurrency Control 12 topics
  • Transaction concepts and transaction system
  • Serializability testing: conflict‑serializable and view‑serializable schedules
  • Recoverability and recovery from transaction failures
  • Log‑based recovery, checkpoints, deadlock handling
  • Concurrency control techniques: locking protocols, timestamp protocols, validation protocols
  • Multiple‑granularity locking and multiversion concurrency control
  • Recovery in concurrent transaction environments
  • Introduction to distributed databases
  • Data mining and data warehousing basics
  • Object‑oriented databases vs. traditional DBMS
  • Comparative study of OODBMS and DBMS
  • Temporal, deductive, multimedia, web and mobile databases
Unit 4 notes
Unit 5 Case Study of Relational DBMS (Oracle/PostgreSQL/MySQL) 12 topics
  • Architecture of major RDBMS (Oracle, PostgreSQL, MySQL)
  • Physical file organization and memory structures
  • Background processes in RDBMS
  • Data dictionary and dynamic performance views
  • Security, role management, privilege management, profiles
  • Invoker‑defined security model
  • Advanced SQL queries: hierarchical, inline, flashback
  • ANSI SQL standards and extensions
  • Cursor management: nested and parameterized cursors
  • Stored procedures and usage of parameters
  • User‑defined functions and their limitations
  • Triggers, mutating table errors, instead‑of triggers
Unit 5 notes
Read the full syllabus

Exam insights

Counted from 5 past AL-502 papers.

Marks asked per paper, by unit

  • Unit 1 DBMS Concepts and architecture 28 marks
  • Unit 2 Relational Data models 28 marks
  • Unit 3 Data Base Design 15 marks
  • Unit 4 Transaction Processing Concepts 24 marks
  • Unit 5 Case Study of Relational Database Management Systems through Oracle/PostgreSQL /MySQL 17 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

  1. Explain keys in the relational model — super key, candidate key, primary key, alternate key and foreign key — with suitable examples.

    Asked 3 times: 2025, 2022

  2. Explain integrity constraints over relations and their types (domain, entity, referential integrity) with suitable examples.

    Asked 3 times: 2025, 2023, 2022

  3. What is a locking protocol? Explain shared locks, exclusive locks and strict two-phase locking protocol for concurrency control.

    Asked 2 times: 2025

Other 5th semester AIML subjects