Assignment
Figure- The Company Schema
About the Company Schema:- All domains include only valid, real world data. In other words, every field must be something in the world.
1. There are errors in the Company Schema. Identify all of the errors.
2. Using ER Diagramming notation, diagram a relational model that is capable of modeling a e-commerce-based company. It should include the following information:
* Customer info (to include shipping information)
* Processing time
* Purchase frequency
* Supplier information
* Inventory
* Warehouse/distribution center information
Do not go overboard. Keep it clean and simple.
3. Using the model you created in the previous problem, use the ER-to-Relational mapping algorithm to create a relational schema. Diagram your schema in a manner similar to Elmasri.
4. Using the mapped schema from the previous question, use the MySQL Workbench to create the schema and the required tables. When you are satisfed with your schema, export it as a SQL le. This SQL file is what you will be submitting for this problem.