Question 6579 – KVS PGT 2017 Paper 1
November 30, 2023Question 16887 – Priority-Queue
November 30, 2023Question 7549 – UGC NET CS 2015 June Paper-3
The Relation Vendor Order (V_no, V_ord_no, V_name, Qty_sup, unit_price) is in 2NF because:
Correct Answer: E
Question 10 Explanation:
A relation is in 2NF if there is no partial dependency in a relation. A
relation will be in 2NF if the LHS of a functional dependency is either a primary key or a non- key attribute or if all the attributes of a relation are prime attributes.
Option(A) is not correct because Non_key attribute V_name is dependent on V_no which is part of composite key i.e there is a partial dependency exists because of V_no.
Option(B) is also not correct because there are chances of having a partial dependency because Qty_sup could be a prime attribute.
Option(C) and Option(D) are correct because in both the options Key attributes depend upon primary key.
relation will be in 2NF if the LHS of a functional dependency is either a primary key or a non- key attribute or if all the attributes of a relation are prime attributes.
Option(A) is not correct because Non_key attribute V_name is dependent on V_no which is part of composite key i.e there is a partial dependency exists because of V_no.
Option(B) is also not correct because there are chances of having a partial dependency because Qty_sup could be a prime attribute.
Option(C) and Option(D) are correct because in both the options Key attributes depend upon primary key.
Non_key attribute V_name is dependent on V_no which is part of composite key
Non_key attribute V_name is dependent on Qty_sup
Key attribute Qty_sup is dependent on primary_key unit price
Key attribute V_ord_no is dependent on primary_key unit price
None of the above
Subscribe
Login
0 Comments