Question: Prepare a separate entity relationship with the cardinalities for the following business rules: Example: Each salesperson is assigned to multiple geographical territories Answer: Salesperson
Prepare a separate entity relationship with the cardinalities for the following business rules: Example: Each salesperson is assigned to multiple geographical territories Answer: Salesperson (1) - Territory (M) 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
