3NF

3NF

PRODUCT (PROD_NUM, PROD_TYPE, PROD_NAME)

CUSTOMER (CUST_ID, CUST_NAME, CUST_ADDRESS, CUST_PHONE)

MANAGER (MANG_ID, MANG_NAME)

REQUEST (VEND_NUM, PROD_NUM, MANG_NAME)

REQUEST LINE (VEND_NUM, PROD_NUM, QUANT_ORDER)

VENDOR (VEND_NUM, VEND_CODE, VEND_NAME)

INVOICE (INV_NUM, CUST_NUM, DATE_SOLD, INV_SUB, INV_TAX, INV_TOTAL)

INV_LINE (INV_NUM, PROD_NUM, QUANT_SOLD)

SALES REP (REP_ID, REP_NAME)


This is the 3NF created from 2NF to remove all of the transitive dependencies. I took out the transitive dependencies out of the PRODUCT table. I created a separate table for the VENDOR to display the VEND_CODE and VEND_NAME. Then a primary key was created called VEND_NUM. A INVOICE LINE was created to show the attributes that would be contained within the INVOICE LINE for invoices. The REQUEST LINE is created for the same purpose of the INVOICE LINE to show the attributes that would be contained within the LINE.