[Solved] Bookstore database Continuation

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.