Crow's Foot ERD, partial dependencies, transitive dependencies, create relations in 3NF Assignment Instructions: Use the database Crow's

Crow's Foot ERD, partial dependencies, transitive dependencies, create relations in 3NF

 

Transcribed Image Text:

Assignment Instructions: Use the database Crow's Foot ERD shown below to answer the following: 1. Identify all partial dependencies. 2. Identify all transitive dependencies. 3. Create relations in 3NF that represent the given Crow's Foot ERD. 4. List the primary keys and the foreign keys associated with the different relations. LINE CUSTOMER CUS_CODE CUS LNAME CUS AREACODE CUS INITIAL CUS BALANCE CUS PHONE CUS_FNAME INVOICE INV_NUMBER INV_DATE CUS_CODE INV_NUMBER LINE NUMBER LINE_UNITS P.CODE LINE PRICE VENDOR V_CODE V NAME V_CONTACT V_PHONE V ORDER V_STATE V_AREACODE H+ PRODUCT P_CODE P_QOH P_DISCOUNT V_CODE P_PRICE P_MIN P.DESCRIPTION P_INDATE Assignment Instructions: Use the database Crow's Foot ERD shown below to answer the following: 1. Identify all partial dependencies. 2. Identify all transitive dependencies. 3. Create relations in 3NF that represent the given Crow's Foot ERD. 4. List the primary keys and the foreign keys associated with the different relations. LINE CUSTOMER CUS_CODE CUS LNAME CUS AREACODE CUS INITIAL CUS BALANCE CUS PHONE CUS_FNAME INVOICE INV_NUMBER INV_DATE CUS_CODE INV_NUMBER LINE NUMBER LINE_UNITS P.CODE LINE PRICE VENDOR V_CODE V NAME V_CONTACT V_PHONE V ORDER V_STATE V_AREACODE H+ PRODUCT P_CODE P_QOH P_DISCOUNT V_CODE P_PRICE P_MIN P.DESCRIPTION P_INDATE