- The Following Is An Example Invoice Table Inv Num Prod Num S Date Prod Label Aa E3422qw 15 Jan 16 Rotary Sander 211347 1 (65.52 KiB) Viewed 19 times
The following is an example INVOICE table: INV_NUM PROD_NUM S_DATE PROD_LABEL AA-E3422QW 15-Jan-16 Rotary sander 211347 211347 QD-300932X 15-Jan-16 0.25-in. drill bit 211347 RU-995748G 15-Jan-16 Band saw 211348 AA-E3422QW 15-Jan-16 Rotary sander 211349 GH-778345P 16-Jan-16 Power drill VEND_CODE 211 211 309 211 157 VEND_NAME NeverFail, Inc. NeverFail, Inc. BeGood, Inc. NeverFail, Inc. ToughGo, Inc. SoldQty P_PRICE 49.95 3.45 39.99 49.95 87.75 1 8 1 2 1 PROD_POSITION Shelf-1 Shelf-2 Shelf-3 Shelf-1 Shelf-5 Based on the Invoice table do the following: 1. Apply 1NF, 2NF, 3NF and BCNF and write the resulting tables/relations in a.docx file. [Please include the resultant relations after every Normalization step] 2. Draw an ERD on the relations that we have after the application of BCNF. Please use "erwin" or MS Visio to draw the ERD and paste it in the same.docx file (as for task 1).