PROJECT#3 Consider the important concepts described in the following scenario: A salesperson may manage many other salespeople. A salesperson is...

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.

______________________

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.