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.
Design the database, following an ER model. (2 Points)
Normalize the tables ( each table should be in 3NF at least) (2 Points)
Use MySQL to create the normalized tables. (2 Points)
Populate your tables with 5 rows at least. (2 Points)
Execute the requested queries. (2 Points)
A Word document to be submitted by each students that should contain:
The an ER diagram for the database.
The normalization process. (show each table in 1NF, 2NF, 3NF)
SQL statements for creating tables and inserting data.
A screen shots for every created table and its data.
SQL queries and their results.
A screen shots for every query and its result.