On Visio

Normalization LAB Using the Sample INVOICE Records (Table 1), write the relational schema (to 3NF), drawing the dependency diagram and identify partial and transitive dependencies. You can assume that the table does not contain repeating groups and that any invoice number may reference more than one product. (Use Excel for creating normalization diagrams). Attribute Name Sample Value INV_NUM 211347 PROD_NUM AA-E3422QW SALE_DATE 15-Sept-2015 PROD LABEL Rotary sander VEND_CODE 211 VEND_NAME Never Fail, Inc. QUANT_SOLD 1 PROD_PRICE $49.95 Table 1 Sample INVOICE Records Sample Value 211347 QD-300932X 15-Sept-2015 0.25-in.drill bit 211 Never Fail, Inc. 8 $3.45 Sample Value 211346 RU-995748G 15-Sept-2015 Band saw 309 BeGood, Inc. 1 $39.99 Sample Value 211348 AA-E3422QW 15-Sept-2015 Rotary sander 211 Never Fail, Inc. 2 $49.95 Sample Value 211349 GH-778345P 16-Sept-2015 Power drill 157 Tough Go, Inc. 1 $87.75 Suggestion: Using Visio, create an ERD based on the 3NF