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.

Option a is wrong as the relationship between the Employee and Customer is "manages". Option b is…

Answered: Consider the following business rule:…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

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 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.

Expert Solution

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions