Search for question
Question

1 Functional Dependencies

The following set of questions attempts to answer the question of where functional de

pendencies come from. In this case, they may come from application's requirements. You

are given the following relation:

Purchase (CustomerID, Product ID, ShopID, Price, Date)

Your task is to identify the precise functional dependencies for each of the specification.

By "precise", it means that the functional dependencies satisfies the requirement and do

not add unnecessary constraints.

Fig: 1

Fig: 2