[Solved] INT2005 LAB 6

ER Modeling

Topic:

1. Know the symbols and vocabulary of UML notation for ERD
2. Use the symbols to represent the Cardinality Classifications: Mandatory, Optional, 1-M, M-N, 1-1
3. Understand important relationship patterns: 1-M, M-N, 1-1.

For more information about MySQL Workbench Data Modeling https://dev.mysql.com/doc/workbench/en/wbdatamodeling.html

Question: According to the given requirements of ABC company, please identify entities and its attributes (your design) and draw a Entity-Relationship Diagram (ERD) using MySQL Workbench.

Requirements:

ABC company, a world-wide company, plan to develop a Sales system to keep and manage sales information of the company. To do this, the company assign some IT staffs to design Sales database. The important data are products, customers, orders, employees and offices. The business constraints are in the following.

• Each CUSTOMER must buy one or more ORDERS. Each ORDER must be belonged to exactly one CUSTOMER.
• Each EMPLOYEE must be assigned to exactly one OFFICE. Each OFFICE may has one or more EMPLOYEES.
• Each PRODUCT may be bought by one or more ORDERS. Each ORDER must have one or more PRODUCTS.
• Each EMPLOYEE may be responsible for one or more CUSTOMERS. Each CUSTOMER must be assigned to exactly one EMPLOYEE.

Instructions:

• Save your diagram as a sales_erd_xxxxx.mwb file stored in your computer.
• Save your diagram [Using the menu: Export > Export as PNG] as an image file with file named sales_erd_xxxxx.png and submit the diagram into LEB2 system Note: xxxxx = your student id