Database Management System Unit 3 – Database Design and Normalization: AKTU previous year questions
23 AKTU questions from Unit 3 (Database Design and Normalization) asked in 2021–2026, tagged by marks, year and topic. In short: about 30 marks of every paper come from this unit; the most asked topic is Functional Dependencies (9 times); 12 questions came back in a later year. The latest ones are listed below; on the page you can filter them by 2-mark or long questions, topic and repeats.
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)
- 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)
- 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)
- Consider the relation R (P, Q, S, T, X, Y, Z, W) with the following functional dependencies. PQ → X; P → YX; Q → Y; Y → ZW Consider the decomposition of the relation R into the constituent relations according to the following two decomposition schemes. D1 : R = [(P, Q, S, T); (P, T, X); (Q, Y); (Y, Z, W)] D2 : R = [(P, Q, S); (T, X); (Q, Y); (Y, Z, W)] Identify whether it is and lossy decomposition and justify your answer. (7 marks, 2025, Lossless Join Decomposition)
- 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)
- 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} }. Identify the key for R? Also define MVD with example. (7 marks, 2025, Normalization Using FD MVD JD)
- 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, 2023, Functional Dependencies)
- Explain MVD with the help of suitable example. (2 marks, 2023, Normalization Using FD MVD JD)
- A set of FDs for the relation R{A, B, C, D, E, F} is AB→C, C→A, BC→D, ACD→B, BE→C, EC→FA, CF→BD, D→E. Find a minimum cover for this set of FDs. (10 marks, 2023, Functional Dependencies)
Most asked Unit 3 topics
- Functional Dependencies – asked 9 times
- Normal Forms – asked 7 times
- Normalization Using FD MVD JD – asked 4 times
Unit 3 question pattern
- 2-mark questions: 8 asked in 2021–2026
- 7-mark questions: 6 asked in 2021–2026
- 10-mark questions: 9 asked in 2021–2026
- About 30 marks from Unit 3 in every paper
- 12 questions were asked again in a later year
Unit 3 questions year by year
- 2026: 4 Unit 3 questions asked (23 marks across that year's papers)
- 2025: 5 Unit 3 questions asked (25 marks across that year's papers)
- 2023: 5 Unit 3 questions asked (34 marks across that year's papers)
- 2022: 4 Unit 3 questions asked (32 marks across that year's papers)
- 2021: 5 Unit 3 questions asked (34 marks across that year's papers)