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 EER 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 innetwork 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
