Question

Problem (40 points) Prepare a separate entity relationship diagram with the cardinalities for the following business rules: 1. The purchasing department prepares many purchase orders, each of which is sent to a specific supplier. 2. Each supplier is able to ship many different inventory items, although each inventory item can be ordered from a specific supplier. 3. Each department has at least one employee. Employees must be assigned to at least one, but possibly more departments. 4. Each department has only one supervisor. Supervisor must oversee at least one department, but possibly more departments.

Answer 1

1)

Company Price Barcode Products purchase department Buy Purchase Orders Purchase order ID Product date Product name Purchase order date Suppliers Product Exp date Quantity Supplier ID Supplier Name Description

2)

Company Buy Products Order ID Suppliers Supply Supply Department Price Orders Order Product date Product name date Barcode Supplier ID Supplier Name Order time Product Exp date Quantity Description

3)

Company Department Name Branches Department Employee Department Email Email Manager ID Stock Department Name Stock

4)

Company Department Name Branches Department Supervisor Department Email Email Department ID Stock Department Name Stock