design a database system for Amazon.com’s product inventory management

• You are asked to design a database system for Amazon.com’s product inventory management.  It handles (a) books, (b) toys and (c) another product of your choice.  Regardless of product types, Amazon wants keep track of internal product ID, product name, barcode #, and retail price.  There are some product specific data items such as publisher information for books, and manufacturer recommended age for toys.  The database system wants to keep track of warehouse location (only one warehouse per product), warehouse inventory, wholesale price and supplier (only one supplier per product).
• Based on the above case, draw a 3NF ER diagram.  For each entity, attributes can be shown as short-hand text notation, attribute names inside the entity box, or bubbles connected to the entity (see the attached examples).  The number of attributes can be a representative few unless the case is explicitly requiring.
• Implement database designs using your SQL Server.  Submit the screen shots of the database table designs and the table relations view. 

Example provided

ERD Deliverables

1) ERD (with attributes)

                Below are format examples.

OR

                              Student (StudentID, StudentLastName, AdvisorID)

                               Advisor (AdvisorID, AdvisorLastName)

OR

2)  Table Relation

               A screenshot of SQL Server database diagram, something like below:

3)  Table Designs

               Screenshots of SQL Server Table designs, something like below:

             If you have 3 tables, make 3 screenshots that show each table design.