Individual Project Unit 2 - Consider a typical sales invoice that would include the following information

Asked by nerdygirl
Dated: 1st May'15 01:41 PM
Bounty offered: $9.99


Individual Project Unit 2

• Due Date: 12/7/2013
• Deliverable Length: Word Document (2–3 paragraphs)
• References: Site References

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 - Individual Project Unit 2 - Consider a typical sales invoice that would include the following information
Answered by nerdygirl
Expert Rating: 200 Ratings
Dated: 1st May'15 01:41 PM
358 words and 0 attachment(s).
Tutorial Rating: Not Rated
Sold 0 times.
(preview of the tutorial; some sections have been intentionally blurred)
…details     table   - data     can       values   between rows     same       columns   different tables     if       to   different address     modify       every   related to     this       inconsistent   ) To     database       form   can follow…