SQL Database Paper

profilejun184

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

THIS ASSIGMENT MUST BE ORGINAL AND NON_PLAGARIZED, ALL ASSIGNMENTS DETAILS MUST BE FOLLOWED!!

    • 9 years ago
    • 7
    Answer(1)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      sql_database_paper.doc
    Bids(0)