Question: can you draw the diagram? Design an ( E ) ER model for the following problem. SimplyBlue is a health insurance company that wishes to

can you draw the diagram?
Design an (E)ER model for the following problem.
SimplyBlue is a health insurance company that wishes to collect data in a database
about their insurance claims. They keep track of their in-network physicians including
their name, physician ID, and the hospital name. As for the customers, SimplyBlue
wishes to collect information such as their customer ID, name, address, and policy
number. When a customer files a claim with respect to a treatment, it contains the
customer ID, physician ID, date of service, medical codes, and total charges. Since each
customer can get treated by a same physician multiple times, a separate
treatmentRecordNo is also maintained in addition to customer ID and physician ID.

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 Programming Questions!