Database Management System Unit 3 Important Questions AKTU

AKTU · BTECH · Semester 5 · Database Management System · Unit 3 · Important Question

AKTU Database Management System (BCS501) Unit 3 important questions for B.Tech Semester 5 – Database Design and Normalization. Topics: Functional…

Open the interactive reader to study this resource on AcademicArk.

Unit 3: Database Design and Normalization – AKTU syllabus topics

  • Functional Dependencies
  • Normal Forms: First Second Third Normal Form, Boyce Codd Normal Form
  • Lossless Join Decomposition
  • Normalization Using FD MVD JD

Most asked AKTU PYQ questions from Unit 3

  1. Q5b. 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, 2022-23)
  2. Q2c. (i) What is highest normal form of the Relation R(W,X,Y,Z) with the set F= { WY → XZ, X →Y } (ii) Consider a relation R(A,B,C,D,E) with set F= { A→CD, C→B,B→AE} What are the prime attributes of this Relation and Decompose the given relation in 3NF. (10 marks, 2020-21)
  3. Q5b. 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, 2025-26)
  4. Q5a. 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.… (7 marks, 2024-25)
  5. Q2c. 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, 2022-23)
  6. Q5b. (i) Consider the relation R(a,b,c,d) with Set F={a→c,b→d}. Decompose this relation in 2 NF. (ii) Explain the Loss Less Decomposition with example. (10 marks, 2020-21)
  7. Q5a. What is Functional Dependency? Explain the procedure of calculating the Canonical Cover of a given Functional Dependency Set with suitable example. (10 marks, 2020-21)
  8. Q2c. 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, 2025-26)
  9. Q2c. 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);… (7 marks, 2024-25)
  10. Q1e. 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, 2024-25)

AKTU paper codes: BCS501, KCS501, RCS501

Other Database Management System units

Database Management System previous year papers

More Database Management System resources

Browse all notes · Semester 5 notes