108k views
2 votes
Customer: An entity that describes a customer. An instance occurs for unique customers only using name, date of birth, and login name as customer_id primary key.

Online: An entity that describes a customer purchasing activity online. An instance occurs when the customer completes the transaction. Customers can purchase more than once.
Visits: An entity that describes a customer purchase in a physical store. An instance occurs if a customer makes or purchase or checks-in using an app. Customers can visit more than once per day.
Satisfaction: An entity that represents data from a recent customer satisfaction survey. An instance occurs when a customer takes the survey. A customer is tracked by login name and can only take the survey one time.
Use the information to match the following relationships. Answers can be reused more than once.
1. The relationship between Customer and Online.
2. The relationship between Customer and Satisfaction.
3. The relationship between Online and Visits.
4. The relationship between Visits and Satisfaction
A. prototype
B. one-to-one
C. Zero-sum
D. one-to-many
E. TOO many F. many-to-many.

User Chike
by
8.1k points

1 Answer

1 vote

Answer:

1. The relationship between customer and Online - One to one

2. The relationship between customer and Satisfaction - One to many

3. The relationship between online and visits - Many to many

4. The relationship between Visits and satisfaction - Prototype

Step-by-step explanation:

The relation ship with customer is often one to one. The customers are required to fill the satisfaction surveys which enable the business to understand their value in the eyes of its customers and try to improve their level of service to their customers. The customer satisfaction is important for any business as the satisfied customer may bring more customers.

User Edwin
by
8.7k points