Use the database Crows Foot ERD shown below to answer the following:

Write down full collection of attributes; from then on

1. Identify all partial dependencies. 2. Identify all transitive dependencies. 3. Create relations in 3NF that represent the given Crows Foot ERD. 4. List the primary keys and the foreign keys associated with the different relations.

LINE CUSTOMER PK INV_NUMBER PK CUS_CODE INVOICE LINE_NUMBER PK CUS_L NAME INV_NUMBER + LINE_UNITS CUS_AREACODE INV_DATE P_CODE CUS_INITIAL CUS_CODE LINE_PRICE CUS_BALANCE CUS_PHONE HT PRODUCT CUS_FNAME PK P_CODE VENDOR P_QOH PK V_CODE P_DISCOUNT V_NAME V_CODE V_CONTACT P_PRICE + V_PHONE P_MIN V_ORDER P_DESCRIPTION V_STATE P_INDATE V_AREACODE LINE CUSTOMER PK INV_NUMBER PK CUS_CODE INVOICE LINE_NUMBER PK CUS_L NAME INV_NUMBER + LINE_UNITS CUS_AREACODE INV_DATE P_CODE CUS_INITIAL CUS_CODE LINE_PRICE CUS_BALANCE CUS_PHONE HT PRODUCT CUS_FNAME PK P_CODE VENDOR P_QOH PK V_CODE P_DISCOUNT V_NAME V_CODE V_CONTACT P_PRICE + V_PHONE P_MIN V_ORDER P_DESCRIPTION V_STATE P_INDATE V_AREACODE