Question: QUESTION Develop an entity-relationship model for the following scenario. Draw it on paper using pen or pencil. You don't have to name the relationships. You

QUESTION

Develop an entity-relationship model for the following scenario. Draw it on paper using pen or pencil. You don't have to name the relationships. You don't have to identify any attributes. No keys needed.

An Insurance Claim is made by one and only one Customer. A customer can make multiple insurance claims. A claim is reviewed by at least one Claims Processor, but may be reviewed by multiple claims processors. A customer may have several

Bank Accounts, or none at all. Bat a bank account has to have at least one customer. A customer can exist without making any insurance claim. A bank account can have at most one customer.

Please draw the ER diagram

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!