### Question 72

When functional dependences through occur as the attributes of the following relation "order," what is the correct set of attributes for the primary key? For this problem, the notation (A, B) represents the pair of attributes A and B. In addition, the notation A → C represents C's functional dependence on A.

Relation "order" (order_number, order_date, customer_number, customer_name, product_number, product_name, quantity, price)

Functional dependences

order_number → order_date

order_number →customer_number

order_number →customer_name

customer_number →customer_name

(order_number, product_number) →quantity

(order_number, product_number) → price

product_number → product_name

a) (order_number)

b) (order_number, customer_number)

c) (order_number, customer_number, product_number)

d) (order_number, product_number)

answer

## No comments:

Post a Comment