SLP 3 CSC

profilerick07

  

Continue this bookstore database (tables) see attachment. Here are your tasks:


1. Normalize the tables. Discuss 1NF, 2NF and 3NF, and whether you believe your tables satisfy each level of normal forms. If all your tables have satisfied the 3NF, explain the reason.

2. Drop the tables no longer needed, and create tables as required in your new design, using SQL in DBMS.

Include the SQL statements and screenshots of your new tables in the paper.

  • 9 years ago
  • 15
Answer(2)

Purchase the answer to view it

blurred-text
  • attachment
    solutions.docx

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    SLP3_CSC31611.docx