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,

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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
