Scenario: A database designer is creating an ERD for a banking system. They encounter a scenario where a customer may have multiple accounts, but an account can only belong to one customer. What type of relationship does this represent in the ERD?

  • Many-to-Many
  • None of the above
  • One-to-Many
  • One-to-One
This scenario represents a One-to-Many relationship in the ERD. In a One-to-Many relationship, one entity instance can be associated with multiple instances of another entity, but each instance of the second entity can only be associated with one instance of the first entity. In this case, one customer can have multiple accounts, but each account can only belong to one customer. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *