Question

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 is a relationship between employee and customer, and a one-to-many relationship between those two entities. b.) the business rules define that there is a relationship between employee and customer, and a one-to-one relationship between those two entities. c.) 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. d.) the business rules define that there is a relationship between employee and customer, and an many-to-many relationship between those two entities requiring a bridge table.

Answer 1

The business rule implies a many-to-many relationship between employees and customers in database design, necessitating a bridge table to link the entities.

Step-by-step explanation:

Considering the business rule that an employee can manage multiple customers and a customer can be managed by multiple employees, this affects the database design by indicating that there is a many-to-many relationship between the employee and customer entities. To handle this relationship in a database, a bridge table, also called a junction table, is typically used to maintain the associations between the two entities. This bridge table would have foreign keys that reference the primary keys of both the employee table and the customer table, creating a link between the tables that allows for the representation of these many-to-many interactions.