Question

Identify functional dependencies for the relation below: ORDER(OrderID, OrderDate, CustomerID, CustomerName, CustomAddress, ProductID, ProductDescription, ProductFinish, ProductStandardPrice, OrderedQuantity).

Answer 1

Answer:

Explanation:

Functional dependency is the relation between two attributes , when a non-prime attribute is dependent on prime attribute.

OrderID -> OrderDate

CustomerID -> CustomerName

CustomerID -> CustomAddress

ProductID -> ProductDescription

ProductID -> ProductFinish

ProductID -> ProductStandardPrice

OrderID,ProductID -> OrderedQuantity

or

The relation is in 1NF. Because a relation is in 1NF if every record is single valued.

Since one customer can have multiple addresses and orders.

decomposing relation into 3 tables.

CUSTOMER(CustomerID, CustomerName)

ORDER(OrderID, OrderDate, CustomerId)

ADDRESS(CustomerID, CustomeAddress)