Question

Consider the scenario described by the statement "A customer can make many payments, but each payment is made by only one customer." Use this scenario as the basis for an entity relationship diagram (ERD) representation.

Answer 1

Answer:

The statement shows that there is a one to many relationship between customer and payment.

Explanation:

A customer can make any number of payments. This means that a single record in Customer table can be associated with one or more records in the Payment table.

However each payment can be associated with only one customer at a time.

Here there are two entities: Customer and Payment.

The relationship between them is "makes". As a person can make many payments and payment is made by one customer.

Relationship makes is represented by a diamond, entities are represented by a rectangle and there is a relationship line from the diamond, connecting the two entities Customer and Payment showing one to many relationship between the entities.

This relationship can be depicted in the form of entity relationship diagram given in the attached file.          

Answer 2

Answer:

One to many relationship

Explanation:

Since the customer can make many payments, and each payment is made by only one customer, this relationship is one-to-many relationship (1:M).

If you would like to draw the ER diagram, see the attached file.