Consider the following business rule: An employee can manage multiple customers. A customer can be managed by multiple employees. How does this business rule(s) affect the database design? a.) The business rules define that there isn't a need for a relationship between the EMPLOYEE and CUSTOMER entities, as the relationship isn't a strong one. b.) The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and a 1:M relationship between those two entities. c.) The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and an M:N relationship between those two entities requiring a bridge table. d.) The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and a 1:1 relationship between those two entities.
Consider the following business rule:
An employee can manage multiple customers. A customer can be managed by multiple employees.
How does this business rule(s) affect the
-
a.)
The business rules define that there isn't a need for a relationship between the EMPLOYEE and CUSTOMER entities, as the relationship isn't a strong one.
-
b.)
The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and a 1:M relationship between those two entities.
-
c.)
The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and an M:N relationship between those two entities requiring a bridge table.
-
d.)
The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and a 1:1 relationship between those two entities.
Option a is wrong as the relationship between the Employee and Customer is "manages".
Option b is wrong as the relationship is many-to-many and not 1:M as one employee manages several customers and a customer can be managed by several employees.
Option d is wrong as the relationship is many-to-many and not 1:1 as one employee manages several customers and a customer can be managed by several employees.
Step by step
Solved in 3 steps
