Question on this E-R model: Give two instances of the CareProvider entity in the

Question

Question on this E-R model:

Give two instances of the CareProvider entity in the E-R model of the healthcare database in Figure 5.19.

(I think I may be on the right track, but not confident with my answer.)

ersonName (Addness Phone mployerPrem nrollmentDat ption GrouplD PlanName SSN Na Patient Offer InsuranceCompanyAddress Age Phone Include rocess Employer Visit E-Name ProviderID Position Claim mergencyContac der ateOfVisit Treatment tientPayme urancePayme Fill rescription Order Languages Pharmacy RecoveryTi rmacyNa Schedule StartTime Quanti Address Symptoms stPickupDa atientNam Phone AffiliatedHospita efi lIF Keep Degree Education Medicine Year ption nitPrice dicine FIGURE 5.19 E-R model of the healthcare database with superclass and subclass entities

Explanation / Answer

In ER -model, Entity Instance is nothing but a single occurance of an entity type.Based on Entity instance we can provide cordinality between two entities. Usually cardinality specifies that how many instances of one entity relate to another entity's instance.

As per given ER-diagram CareProvider is an entity in healthcare database ER model.
Careprovider entity having instance cordinality with insurence plan and person.
There is only one insurance plan for one carprovider.
Another one is person, one careprovider may treat or check so many people.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.