Individual Project Unit 2

Question # 00004539 Posted By: expert-mustang Updated on: 12/04/2013 12:54 AM Due on: 12/04/2013
Subject Computer Science Topic General Computer Science Tutorials:
Dot Image

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.

• 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
Dot Image
Tutorials for this Question
  1. Tutorial # 00004337 Posted By: expert-mustang Posted on: 12/04/2013 12:56 AM
    Puchased By: 4
    Tutorial Preview
    first table would include the following fields: • Order_id, Numeric (...
    Attachments (86 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    j...r76 Rating 100% proofread tutorials 05/23/2014
    ac...ton Rating Tutorials helped score A+ grades 03/23/2014

Great! We have found the solution of this question!

Whatsapp Lisa