dicussion

i need original work not copy and everything exact they ask i need that

 Word Document attachment and 150-200 word description

first question

Consider this assignment and post your opinion on ONE of the following questions.

• How does using diagrams, building data relationships using entities and attributes is going to help the designer organize, plan and implement a solution to a common problem?  How do these tools provide insights in troubleshooting a design?

second question

Complete the main portion of this assignment as outlined below. When applicable, adhere to APA formatting and reference guidelines.

Consider a typical sales invoice that would include the following information:

• 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

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. Attach a Word document showing the original and final tables. Describe the problems with the original single table design and how normalization improved the design.