Sign up now
to enroll in courses, follow best educators, interact with the community and track your progress.
Download
GATE 2002, GATE 2008 and GATE 2016 Question on Normalization (in Hindi)
293 plays

More
This course will cover Normalization in Databases with 25 Previous Year Questions plus some practice questions from beginning level to expert.

Sweta Kumari is teaching live on Unacademy Plus

Sweta Kumari
YouTuber (channel : GATE NoteBook) | Verified Educator | 2+ year Online Teaching Experience

U
Unacademy user
Informative . Well done !!!!
maam you have given the trick that if there is one c.k then it should be in 3nf,bcnf so this trick does not work on the last question?
Sweta Kumari
7 months ago
Thanks 😊
  1. Which of the following is NOT a superkey in a relational schema with attributes V, W, X, Y, Z and primary key VY? (A) VXYZ (B)VWX:Z Relation R is decomposed using a set of functional dependencies, F and relation S is decomposed using another set of functional dependencies G. One decomposition is definitely BCNF, the other is definitely 3NF, but it is not known which is which. To make a guaranteed identification, which one of the following tests should be used on the decompositions? (Assume that the closures of F and G are available) (A) Dependency-preservation (B) Lossless-join (C) BCNF definition (D) 3NF definition (C) V WxY (D) VWX YZ GATE 2016 Let R (A, B, C, D, E, P, G) be a relational schema in which the following functional dependencies are known to hold: schema R is (A) in BCNF (B) in 3NF, but not in BCNF (C) in 2NF, but not in 3NF (D) not in 2NF GATE 2002 GATE 2008 NORMALIZATION GATE PROBLEMS


  2. Which of the following is NOT a superkey in a relational schema with attributes V, W, X, Y, Z and primary key VY (A) VX Y Z (B)vwxz Relation R is decomposed using a set of functional dependencies, F and relation S is decomposed using another set of functional dependencies G. One decomposition is definitely BCNF, the other is definitely(C) VwxY 3NF, but it is not known which is which. To make a guaranteed identification, which one of the following tests should be used on the decompositions? (Assume does not include Y which is a part of PK or candidate key. that the closures of F and G are available) (A) Dependency-preservation (B) Lossless-join GATE 2016 aely Yz attribu No c osslessandecoofthake (C) BCNF definition (D) VWXYZ Super key Candidate Key+ other attributes. But option B GATE 2002 NORMALIZATION GATE PROBLEMS Let R (A, B, C, D, E, P, G) be a relational schema in which (D) 3NF definition Answer is (C) since to identify BCNF we need BCNF definition. One relation which satisfies will be in BCNF and AB CD, DE P, C E, P and B G. The relational other will be in 3NF. 1st is wrong because dependency may be preserved by A) in BCNF both 3NF and BCNF. 2nd is wrong Because both 3NF and BCNF decomposition (C) in 2NF, but not in 3NF can be lossless 4th is wrong because 3NF and BCNF both are in 3NF also. Candidate key AB the following functional dependencies are known to hold: schema R is (B) in 3NF, but not in BCNF (D) not in 2NF B->G is partial dependency GATE 2008 So, not in 2NF