zip

[SOLVED] Bookstore database Continuation

25.00 $

Programming resource
Digital learning resource
Category:
✓ Practical programming resource
✓ Suitable for guided study and reference
✓ Tutor guidance available when needed

Description

Rate this product

Continue this bookstore database (tables) below. 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.

Related Programming Resources

Resource details

Understand the Task Before You Use the Resource

Review the requirements, identify the programming concepts involved, study the implementation and test your understanding with your own examples and modifications.