i need help on my database project :

Consider the important concepts described in the following scenario:

• A salesperson may manage many other salespeople. A salesperson is managed by only one salespeople. A salesperson can be an agent for many customers.
• A customer is managed by one salespeople. A customer can place many orders. An order can be placed by one customer. An order lists many inventory items. An inventory item may be listed on many orders.
• An inventory item is assembled from many parts. A part may be  assembled into many inventory items. Many employees assemble an inventory item  from many parts. A supplier supplies many parts. A part may be supplied by many  suppliers.

The deadline to submit the project is 10/04/2016.

 

1. Design the database, following an ER model.                                   (2 Points)                        
2. Normalize the tables ( each table should be in 3NF at least)            (2 Points)
3. Use MySQL to create the normalized tables.                                    (2 Points)
4. Populate your tables with 5 rows at least.                                         (2 Points)           
5. Execute the requested queries.                                                           (2 Points)

 

Final Deliverables:

 

A Word document to be submitted by each students that should contain:

 

1. The an ER diagram for the database.                                                      
2. The normalization process. (show each table in 1NF, 2NF, 3NF)         
3. SQL statements for creating tables and inserting data.                          
4. A screen shots for every created table and its data.                                  
5. SQL queries and their results.                                                                 
6. A screen shots for every query and its result.