Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

GATE | GATE-CS-2016 (Set 1) | Question 33

  • Last Updated : 28 Sep, 2017

A database of research articles in a journal uses the following schema.

(VOLUME, NUMBER, STARTPGE, ENDPAGE, TITLE, YEAR, PRICE) 

The primary key is (VOLUME, NUMBER, STARTPAGE, ENDPAGE) and the following functional dependencies exist in the schema.

Attention reader! Don’t stop learning now.  Practice GATE exam well before the actual exam with the subject-wise and overall quizzes available in GATE Test Series Course.

Learn all GATE CS concepts with Free Live Classes on our youtube channel.

(VOLUME, NUMBER, STARTPAGE, ENDPAGE) -> TITLE
(VOLUME, NUMBER)                     -> YEAR
(VOLUME, NUMBER, STARTPAGE, ENDPAGE) -> PRICE 

The database is redesigned to use the following schemas.



(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?

(A) 1NF
(B) 2NF
(C) 3NF
(D) BCNF


Answer: (B)

Explanation: Old relation has functional dependency : Volume, Number -> Year as partial dependency. So it does not follow 2NF.
But, there is no partial dependency in the New relation and so it satisfies 2NF as well as 3NF.

Therefore, 2NF is the weakest normal form that the new database satisfies, but the old one does not.
Option (B) is true.

Quiz of this Question

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!