Can you provide an ERD diagram on LucidChart or Draw.io and Normalize the invoice to UNF, 1NF, 2NF and 3NF?

 

Transcribed Image Text:

Invoice Number: 1 Customer Number: 78 Customer Name: YORK UNIVERSITY Items Purchased: Date: 07-May-2002 Prod Id 100861 Prod. Name and Edition Quantity Price Total Database Systems: Design And Implementation, Fourth Edition 2 109.20 218.40 100890 Understanding Microsoft Access, 3 72.80 218.40 Ninth Edition 102130 Oracle: Introduction To PL/SQL 5 59.15 295.75 Sub-Total: 732.55 PST (8%): 58.60 GST (7%): 51.28 Total: $842.43 Invoice Number: 1 Customer Number: 78 Customer Name: YORK UNIVERSITY Items Purchased: Date: 07-May-2002 Prod Id 100861 Prod. Name and Edition Quantity Price Total Database Systems: Design And Implementation, Fourth Edition 2 109.20 218.40 100890 Understanding Microsoft Access, 3 72.80 218.40 Ninth Edition 102130 Oracle: Introduction To PL/SQL 5 59.15 295.75 Sub-Total: 732.55 PST (8%): 58.60 GST (7%): 51.28 Total: $842.43