Give two instances of the InsuranceCompany entity in the ER

Give two instances of the InsuranceCompany entity in the E-R model of the healthcare database.

PersonName Address Phone Gender Person mployerP remium emberPremium nrollmentDat on GroupID ependO PlanName MemberlD 0 ID SSN PlanID mpanyName DateOfBirth Patient Enroll nsurancePlan Offer InsuranceCompany Address ompanyAddress Age Phone Include rocesS PatientID ProviderID ClaimID ateOfVisit Employer Visit E-Name Position Claim E-PhoneEmergencyContac enerate CareProvider ClaimID) Sevice Balance Treatment ceCode S erviceName PatientPaymentInsurancePayment Fill rescriptionID Order Disease Languages har ID Pharmacy Prescription RecoveryTime harmacyNa Schedule StartTime Quant ast PickupDat RefillFrequen Symptoms Specialt AffiliatedHospita Education Address Contain atientName Phone Keep Degree Medicine Year escription nitPrice urrentInvento inimumInvento MedicineIDMedicineName FIGURE 5.19 E-R model of the healthcare database with superclass and subclass entities.

Solution

Two Instances of the Enroll Relationship

Patient ID    Plan ID    Enrollment Date Group ID        Member ID

PA5           PL3          03/01/2015         40400               5678900

PA6           PL3          03/01/2015         40400                 5678906    

_____________________________________________________________________________________