Home › AKTU PYQ › Database Management System › Important Questions › Unit 3

Database Management System Unit 3 – Database Design and Normalization: important questions for AKTU

Unit 3 (Database Design and Normalization) questions that AKTU repeats most often. This unit carries about 30 marks per paper. Start with the repeated questions, then the most asked topics.

Most repeated Unit 3 questions

  • Consider the universal relational schema R (A, B, C, D, E, F, G, H, I, J) and a set of following functional dependencies. F ={AB→C, A→DE, B→F, F →GH, D→IJ} Determine the keys for R? Decompose R into 2nd Normal Form. (7 marks, 2026, Normal Forms) – also asked in 2021, 2023, 2025
  • Consider the following relational schemes for a library database: Book (Title, Author, Catalog_no, Publisher, Year, Price), Collection (Title, Author, Catalog_no) with in the following functional dependencies: I. Title Author --> Catalog_no II. Catalog_no --> Title, Author, Publisher, Year III. Publisher Title Year --> Price Analyze and find the highest normal form of the relation Book and Collection. (7 marks, 2025, Normal Forms) – also asked in 2021, 2023, 2026
  • Consider the universal relation R = {A, B, C, D, E, F, G, H, I, J} and the set of functional dependencies F = { {A,B}→{C}, {A}→{D,E}, {B}→{F}, {F}→{G,H}, {D}→{I,J} }. What is the key for R? Decompose R into 2NF and then 3NF relations. (10 marks, 2023, Normal Forms) – also asked in 2021, 2025, 2026

Most important Unit 3 topic

  • Functional Dependencies (Unit 3: Database Design and Normalization) – asked 9 times in 2021, 2022, 2023, 2025

Most asked Unit 3 topics

  • Functional Dependencies – asked 9 times
  • Normal Forms – asked 7 times
  • Normalization Using FD MVD JD – asked 4 times

More Unit 3 previous year questions

  • Define 3 NF. (2 marks, 2026, Normal Forms)
  • Consider R = (A, B, C, D, E, F, G, H) and F= { AB→ C, BC→ D, E → F, G → F, H → A, FG → H } Is the decomposition of R into R1(A, B, C, D), R2(A, B, C, E, F), R3(A, D, F, G, H) lossless? Is it dependency preserving? (7 marks, 2026, Lossless Join Decomposition)
  • Short Notes of the Following- i) MVD or JD ii) Normalization with advantages (7 marks, 2026, Normalization Using FD MVD JD)
  • Analyze and find the FDS in the following relation X Y Z 1 4 2 2 5 3 1 4 2 3 2 2 (2 marks, 2025, Functional Dependencies)
  • List all prime and non-prime attributes In Relation R(A,B,C,D,E) with FD set F = {AB→C, B→E, C→D}. (2 marks, 2025, Functional Dependencies)

Unit 3 syllabus topics

  • Functional Dependencies
  • Normal Forms
  • Lossless Join Decomposition
  • Normalization Using FD MVD JD