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