Chapter 2, Problem 2P

Explanation of Solution

Crow’s Foot notation:

In the Crow’s Foot model by the three-pronged crow’s foot to exhibit the “many” side relationship.

• In this notation, “1”is represented as a short line segment.
• “M” is represented as three-pronged crow’s foot.
• The relationship name is represented above the relationship line.

Crow’s Foot ERD (Entity Relationship Diagram):

• The business rule in the problem 1 in the textbook describes about the relationship between AGENT and CUSTOMER and it is written as follows.
  • One agent can have many customers, but each customer has only one agent...