Home › AKTU PYQ › Database Management System

Database Management System (BCS501) AKTU PYQ analysis – unit-wise weightage

We analysed 118 questions from 5 AKTU Database Management System papers (2021–2026). Here is how marks are spread across units and which topics keep coming back.

Database Management System unit-wise weightage

  • Unit 1: Introduction and ER Model – 30% of questions, about 30 marks per paper
  • Unit 2: Relational Model and SQL – 31% of questions, about 31 marks per paper
  • Unit 3: Database Design and Normalization – 30% of questions, about 30 marks per paper
  • Unit 4: Transaction Processing and Distributed DB – 35% of questions, about 35 marks per paper
  • Unit 5: Concurrency Control Techniques – 23% of questions, about 23 marks per paper

Most repeated Database Management System topics in AKTU PYQs

  • Transaction Processing Concepts
  • Data Model Schema Instances
  • Relational Data Model
  • SQL Queries and Operations
  • Functional Dependencies

Unit 1 (Introduction and ER Model) – top topics

  • Data Model Schema Instances – asked 9 times, last in 2026
  • Database System Overview – asked 8 times, last in 2026
  • Entity Relationship Model – asked 8 times, last in 2026

Unit 2 (Relational Model and SQL) – top topics

  • Relational Data Model – asked 9 times, last in 2026
  • SQL Queries and Operations – asked 9 times, last in 2026
  • SQL Basics and Commands – asked 4 times, last in 2025

Unit 3 (Database Design and Normalization) – top topics

  • Functional Dependencies – asked 9 times, last in 2025
  • Normal Forms – asked 7 times, last in 2026
  • Normalization Using FD MVD JD – asked 4 times, last in 2026

Unit 4 (Transaction Processing and Distributed DB) – top topics

  • Transaction Processing Concepts – asked 21 times, last in 2026
  • Deadlock Handling – asked 3 times, last in 2025
  • Log Based Recovery Checkpoints – asked 2 times, last in 2025

Unit 5 (Concurrency Control Techniques) – top topics

  • Locking Techniques Concurrency – asked 5 times, last in 2026
  • Timestamp Protocols Concurrency – asked 5 times, last in 2025
  • Validation Based Protocol – asked 3 times, last in 2026