2NF

2NF

PRODUCT (PROD_ID, PROD_NAME, PROD_TYPE, VEND_CODE, VEND_NAME
Transitive Dependencies – VEND_CODE, VEND_NAME

CUSTOMER (CUST_ID, CUST_NAME, CUST_ADDRESS, CUST_PHONE)

INVOICE (INV_NUM, INV_SUB, DATE_SOLD)


Here is the 2NF created from the 1NF. Here I took out all of the partial dependencies from 1NF and put them into separate tables. Since it is in 2NF then there should transitive dependencies still. The transitive dependency is in the PRODUCT table; VEND_CODE and VEND_NAME. The transitive dependencies will be taken out in 3NF.