Open In App

UGC-NET | UGC NET CS 2015 Jun – III | Question 10

Like Article
Like
Save Article
Save
Share
Report issue
Report

The Relation
Vendor Order (V_no, V_ord_no, V_name, Qty_sup, unit_price) is in 2NF because:
(A) Non_key attribute V_name is dependent on V_no which is part of composite key
(B) Non_key attribute V_name is dependent on Qty_sup
(C) Key attribute Qty_sup is dependent on primary_key unit price
(D) Key attribute V_ord_no is dependent on primary_key unit price


Answer: (A)

Explanation: The Relation
Vendor Order (V_no, V_ord_no, V_name, Qty_sup, unit_price) is in 2NF because:
Non_key attribute V_name is dependent on V_no which is part of composite key.
For more information on Normal forms Refer:Database Normalization | Normal Forms
Option (A) is correct.

Quiz of this Question


Last Updated : 19 Jun, 2018
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads