Normalization, Relationships, and Constraints

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.

Apply normalization to reduce this table to third normal form.

Prepare a Word document showing the original and final tables.

Include a short summary of the problems with the original single table design and how normalization improved the design.


•Order_id •Order_date •Customer_id •Customer_name •Customer_address •Customer_city •Customer state •Item_id •Item_description •Item_qty •Item_price •Itemization_price •Order total_price














Sample Solution