Please show your work Using the Sample INVOICE Records (Table 1), write the rela
ID: 3662554 • Letter: P
Question
Please show your work
Using the Sample INVOICE Records (Table 1), write the relational schema (to 3NF), drawing the dependency diagram and identify all dependencies, including 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. (Excel is a good tool to use for creating normalization diagrams) Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value INV NUM 211347 211347 211347 21 1348 21 1349 PROD NUM AA-E34220W QD-300932X RU-995748G AA-E34220 W GH-778345 SALE DATE 15-Sept-2015 15-Sept-2015 15-Sept-2015 15-Sept-2015 16-Sept-2015 Rotary sander Power drill PROD LABEL Rotary sander 0.25-in. drill bit Band saw VEND CODE 211 309 157 211 211 VEND NAME NeverFail, Inc. NeverFail: Inc. BeGood, Inc. NeverFail, Inc. ToughGo, Inc. QUANT SOLD 1 8 PROD PRICE $49.95 $3.45 $39.99 $49.95 $87.75 Table 1 Sample INVOICE RecordsExplanation / Answer
Normalization is the process for assigning attributes to entities. Properly executed, the normalization process eliminates uncontrolled data redundancies, thus eliminating the data anomalies and the data integrity problems that are produced by such redundancies.
Normalization does not eliminate data redundancy; instead, it produces the carefully controlled redundancy that lets us properly link database tables.
A table is in 3NF when it is in 2NF and it contains no transitive dependencies.
A partial dependency exists when an attribute is dependent on only a portion of the primary key. This type of dependency is associated with 1NF.