Invoice Normalization

Analyze the Invoice picture below and apply the normalization techniques discussed in class to document an Entity Relationship Diagram of the table(s) required to represent the Invoice in a relational database.

INVOICE LOGO East Repair Inc. 1912 Harvest Lane New York, NY 12210 BILL TO John Smith 2 Court Square New York, NY 12210 SHIP TO John Smith 3787 Pineview Drive Cambridge, MA 12210 INVOICE # INVOICE DATE P.O.# DUE DATE US-001 11/02/2019 2312/2019 26/02/2019 QTY DESCRIPTION UNIT PRICE AMOUNT 1 Front and rear brake cables 100.00 100.00 2 New set of pedal arms 15.00 3 Labor 3hrs 5.00 Subtotal 145.00 Sales Tax 6.25% 9.06 TOTAL $154.06 TERMS & CONDITIONS Payment is due within 15 days Thank you Please make checks payable to: East Repair Inc. Pema mate de parede de la hora de INVOICE LOGO East Repair Inc. 1912 Harvest Lane New York, NY 12210 BILL TO John Smith 2 Court Square New York, NY 12210 SHIP TO John Smith 3787 Pineview Drive Cambridge, MA 12210 INVOICE # INVOICE DATE P.O.# DUE DATE US-001 11/02/2019 2312/2019 26/02/2019 QTY DESCRIPTION UNIT PRICE AMOUNT 1 Front and rear brake cables 100.00 100.00 2 New set of pedal arms 15.00 3 Labor 3hrs 5.00 Subtotal 145.00 Sales Tax 6.25% 9.06 TOTAL $154.06 TERMS & CONDITIONS Payment is due within 15 days Thank you Please make checks payable to: East Repair Inc. Pema mate de parede de la hora de