Design a single table to hold all of the information


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.

Solution Preview :

Prepared by a verified Expert
PL-SQL Programming: Design a single table to hold all of the information
Reference No:- TGS01715473

Now Priced at $40 (50% Discount)

Recommended (91%)

Rated (4.3/5)