Home › AKTU PYQ › Database Management System › Exam Strategy

Database Management System (BCS501) AKTU exam strategy

Focus on Unit 4 (Transaction Processing and Distributed DB) and Unit 2 (Relational Model and SQL). Together they account for about 66 marks among all questions printed per paper. Unit 5 (Concurrency Control Techniques) is safest to skim if you're short on time.

Unit priority

  • Unit 4 (Transaction Processing and Distributed DB) – Must Prepare, 35 marks avg. Unit 4 (Transaction Processing and Distributed DB) averages 35 marks per paper — one of the heaviest units in this subject. Transaction Processing Concepts has appeared in every paper analysed — these are must-dos. Must-do: Transaction Processing Concepts, Deadlock Handling, Log Based Recovery Checkpoints.
  • Unit 2 (Relational Model and SQL) – High Priority, 31 marks avg. Unit 2 (Relational Model and SQL) averages 31 marks per paper — one of the heaviest units in this subject. Relational Data Model and SQL Queries and Operations have appeared in every paper analysed — these are must-dos. Must-do: Relational Data Model, SQL Queries and Operations, SQL Basics and Commands, Cursors Triggers Procedures.
  • Unit 1 (Introduction and ER Model) – High Priority, 30 marks avg. Unit 1 (Introduction and ER Model) averages 30 marks per paper — one of the heaviest units in this subject. Database System Overview and Data Model Schema Instances have appeared in every paper analysed — these are must-dos. Must-do: Data Model Schema Instances, Database System Overview, Entity Relationship Model.
  • Unit 3 (Database Design and Normalization) – Medium Priority, 30 marks avg. Unit 3 (Database Design and Normalization) averages 30 marks per paper — one of the heaviest units in this subject. Must-do: Functional Dependencies, Normal Forms, Normalization Using FD MVD JD, Lossless Join Decomposition.
  • Unit 5 (Concurrency Control Techniques) – Safe to Skim, 23 marks avg. Unit 5 (Concurrency Control Techniques) averages 23 marks per paper — one of the heaviest units in this subject. Must-do: Locking Techniques Concurrency, Timestamp Protocols Concurrency, Validation Based Protocol, Recovery with Concurrent Transactions.

Topics AKTU keeps repeating

  • Database System Overview: Asked in 5 out of 5 papers. If you prepare only one topic from its unit, make it this one.
  • Data Model Schema Instances: Asked in 5 out of 5 papers. If you prepare only one topic from its unit, make it this one.

Short on time?

  • Among all units, Unit 5 (Concurrency Control Techniques) is the lowest priority at 23M avg. If you're running low on time, prioritize the top 3 units and give this one a quick read. But even here — Locking Techniques Concurrency, Timestamp Protocols Concurrency, Validation Based Protocol are high-repeat topics. Cover these at minimum to stay safe.

How the paper is marked

  • Section A: 7 questions × 2 marks = 14 marks. Short definition/concept questions from all 5 units. Prepare 2–3 key definitions per unit — this section is the easiest 14 marks you can secure.
  • Section B: Attempt any 3 of 5 questions × 7 marks = 21 marks. Choose the 3 questions from units you've prepared most. Don't attempt all 5 — pick your strongest 3 and write them well.
  • Section C: 5 OR-pairs × 7 marks = 35 marks. One pair per unit — you must attempt all 5. This is where the exam is won or lost. Focus your deep preparation on the top 3 priority units.

Exam-day tips

  • Start with Section A to build momentum — budget 15–20 minutes max for all 7 questions.
  • In Section B, Unit 4 (Transaction Processing and Distributed DB) questions have the highest repeat rate — always attempt that one first.
  • For Section C OR-pairs, read both options before choosing — sometimes the 'b' option is simpler despite appearing longer.
  • If you've prepared the VERY LIKELY topics, you can comfortably score 50+ marks without touching any new topic on exam day.
  • This strategy is built on 5 past papers — the patterns here are highly reliable.