Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

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.                        
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question