Starting from:

$15

SQL database project Solution

Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this information. Next, apply normalization to reduce this table to third normal form. Prepare a Word document showing the original and final tables. Include a short summary (2–3 paragraphs) of the problems with the original single table design and how normalization improved the design.



Orders:



Order_id

Order_date

Customer_id

Customer_name

Customer_address

Customer_city

Customer_state

Item_id

Item_description

Item_qty

Item_price

Item_total_price

Order_total_price

More products