IEE $305,$ Exercise $2\mathrm{.}4$

Name:

$1.$ Transform the following E$-$R model into a relational data model. The attributes of PERSON

are SSN$,$ Name, Address.

$2.$ DEPENDENT is a weak entity with the attributes, DependentName, Birthday, and Gender. This

weak entity depends on a strong entity, POLICYHOLDER, which has the attributes,

PolicyHolderID and PolicyHolderName. Use a relational model to represent the data.

$3.$ Transform the following E$-$R model to a relational model.

PatientDateOfBirth

Employer

Position

EmergencyContact

E$-$Name

E$-$Phone

InsurancePlanEnroll O $|$

MemberID

PlanID

PlanName

Description

MemberPremium

EmployerPremium

EnrollmentDate

GroupID

DependOn

Age

$>|$

Person

O

PersonName Address