Suppose you had an entity with the following attributes (see posted data dictionary):

INV_NUMBER, LINE_NUMBER, INV_DATE, CUS_CODE, P_CODE, P_PRICE, P_DESCRIPTION, LINE_UNITS, LINE_PRICE, V_CODE, V_NAME

where (INV_NUMBER, LINE_NUMBER) is a composite primary key. 

Answer the following questions:

1. Identify all partial dependencies.
2. Identify all transitive dependencies.

Make sure to justify your answers, e.g. if A -> B is a partial dependency (where A and B are two of the attributes) you need to explain why it is a partial dependency.

 

Transcribed Image Text:

Customer Invoice Line Product Vendor Fields CUS CODE CUS LNAME CUS AREACODE CUS INITIAL CUS BALANCE CUS PHONE CUS FNAME INV NUMBER INV_DATE CUS CODE INV NUMBER LINE NUMBER LINE UNITS P CODE LINE PRICE P_CODE P QOH P DISCOUNT V_CODE P PRICE P MIN P_DESCRIPTION P INDATE V CODE V_NAME V_CONTACT V_PHONE V ORDER V_STATE V_AREACODE Definition Code that uniquely identifies customer Last name Customer area code Middle initial Balance to be paid by the customer 7 digit phone number First name Number uniquely identifying the invoice Invoice date Customer linked to invoice Number uniquely identifying the invoice Invoice line number Number of units purchased of this product Product code Price for one unit of this product Code uniquely identifying the product Quantity on hand in units Product specific discount Vendor code Product price for one unit Minimum number of units to hold in stock Product description Date product came in last Code uniquely identifying the Vendor Vendor name Vendor contact Vendor 7 digit phone number Flag indicating whether the Vendor was previously used Vendor state Vendor area code Customer Invoice Line Product Vendor Fields CUS CODE CUS LNAME CUS AREACODE CUS INITIAL CUS BALANCE CUS PHONE CUS FNAME INV NUMBER INV_DATE CUS CODE INV NUMBER LINE NUMBER LINE UNITS P CODE LINE PRICE P_CODE P QOH P DISCOUNT V_CODE P PRICE P MIN P_DESCRIPTION P INDATE V CODE V_NAME V_CONTACT V_PHONE V ORDER V_STATE V_AREACODE Definition Code that uniquely identifies customer Last name Customer area code Middle initial Balance to be paid by the customer 7 digit phone number First name Number uniquely identifying the invoice Invoice date Customer linked to invoice Number uniquely identifying the invoice Invoice line number Number of units purchased of this product Product code Price for one unit of this product Code uniquely identifying the product Quantity on hand in units Product specific discount Vendor code Product price for one unit Minimum number of units to hold in stock Product description Date product came in last Code uniquely identifying the Vendor Vendor name Vendor contact Vendor 7 digit phone number Flag indicating whether the Vendor was previously used Vendor state Vendor area code