Computer Science

profileVishal Vij
bratiti_u17-assign_1-normalisation_ans.docx
Home>Computer Science homework help>Computer Science

( CUSTOMER_NUMBER CUSTOMER_NAME CUSTOMER_ADDRESS PRODUCT_NUMBER PRODUCT_DESC PRODUCT_UNIT_PRICE ORDER_NUMBER ORDER_DATE ORDER_TOTAL ORDER_QUANTITY LINE_TOTAL )UNF

1NF

TO IDENTIFY AND REMOVE REPEATING ATTRIBUTES

( ORDER_ NUMBER ( CK) PRODUCT_ NUMBER ( CK) PRODUCT_DESC PRODUCT_UNIT_PRICE ORDER_QUANTITY LINE_TOTAL ) ( ORDER_ NUMBER ( PK) ORDER_DATE ORDER_TOTAL CUSTOMER_NUMBER CUSTOMER_NAME CUSTOMER_ADDRESS )

2NF

REMOVE PARTIAL KEY DEPENDENCIES

( ORDER _ NUMBER ( CK) PRODUCT_ NUMBER ( CK) ORDER_QUANTITY LINE_TOTAL ) ( PRODUCT_ NUMBER ( PK) PRODUCT_DESC PRODUCT_UNIT_PRICE ) ( ORDER_ NUMBER ( PK) ORDER_DATE ORDER_TOTAL CUSTOMER_NUMBER CUSTOMER_NAME CUSTOMER_ADDRESS )

( ORDER_ NUMBER ( PK) ORDER_DATE ORDER_TOTAL CUSTOMER_ NUMBER( FK) ) ( CUSTOMER_ NUMBER( PK) CUSTOMER_NAME CUSTOMER_ADDRESS )3NF ( ORDER_ NUMBER ( CK) PRODUCT_ NUMBER ( CK) ORDER_QUANTITY LINE_TOTAL ) ( PRODUCT_ NUMBER ( PK) PRODUCT_DESC PRODUCT_UNIT_PRICE )