Sign up now
to enroll in courses, follow best educators, interact with the community and track your progress.
Download
GATE 2004, GATE 2008 and GATE 2016 : Highest NF, Weakest NF (in Hindi)
227 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
Sir You have any plan to upload English DNA. We expect you will be treat every csnditate in equal manner. please reply to me as early as possible.cbfdb as of thaatt mannner
Mam, 4NF ke liye check kyun nahi kiya.
  1. GATE 2008 A database of research articles in a journal uses the following schema. (VOLUME, NUMBER, START PAGE, ENDPAGE, TITLE, YEAR, PRICE) Let R (A, B, C, D,E, P, G) be The primary key is (VOLUME, NUMBeR, START PAGE, ENDPAGE ) and a schema, FD are the following functional dependencies exist in the schema. (VOLUME, NUMBER, STARTPAGE, EN DPAGE ) TITLE (VOLUME, NUMBER) (VOLUME, NUMBER , STARTPAGE, ENDPAGE ) PRICE The database is redesigned to use the following schemas YEAR AB CD DE P (VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, PRICE) (VOLUME, NUMBER, YEAR) Which is the weakest normal form that the new database satisfies, but the old one does not? 1. 1NF 2. 2NR 3. 3NF 4. BCNF What is the highest degree of NF? GATE 2016


  2. GATE 2016 GATE 2008 A database of research articles in a journal uses the following schema. VOLUME, NUMBER, START PAGE, ENDPAGE, TITLE, YEAR, PRICE) The primary key is (VOLUME, NUMBER, START PAGE, ENDPAGE) and the following functional dependencies exist in the schema (VOLUME, NUMBER, STARTPAGE, ENDPAGE ) TITLE (VOLUME, NUMBER) (VOLUME, NUMBER, STARTPAGE, ENDPAGE)-PRICE The database is redesigned to use the following schemas. Let R (A, B, C, D,E, P, G) be a schema, FD are YEAR ABCD (VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, PRICE) (VOLUME, NUMBER, YEAR) Which is the weakest normal form that the new database satisfies, but the old one does not? 1. 1NF 2. 2NFThe Old relation schema design is in 1NF because it has 3. 4. BCNFpartial dependency so the original database design is in What is the highest degree of NF? C.K A, B NPA-C, D, E, P,G 3NF functional dependency: Volume, NumberYear as a Since, G is partially dependent on B. Therefore , it is not in 2nd NF. 1 NF 1NF but not in 2NF. Now, the new relation schema design removes all partial dependencies, so it is in 2NF as well as in 3NF. Therefore, 2NF is the weakest normal form that the new database satisfies, but the old database does not.


  3. GATE 2004 The relation scheme Student Performance (name, courseNo, rollNo, grade) has the following functional dependencies: name, courseNo grade rollNo, courseNo> grade name > rollNo rollNo name The highest normal form of this relation scheme is (A) 2 NF (B) 3 NF (C) BCNF(A,B,C,D) (D) 4NF Let's say attributes (name, courseNo, rollNo, grade) be FDs are as follows: AB->D, CB->D, A->C, C->A Here there are two Candidate keys, AB and CB. Now AB->D and CB->D satisfy BCNF as LHS is superkey in both. But, A->Cand C->A, doesn't satisfy BCNF. Hence we checkfor 3NF for these 2 FDs. As C and A on RHS of both the FDs are prime attributes, they satisfy 3NF. Hence for the whole relation the highest normal form is 3NF.