In: Computer Science
Create an E/R diagram for the following business situation and convert the diagram into a set
of related tables: A health insurance company sells a number of insurance policies. Employer
companies can buy any number of policies including zero and up to 4. A policy must be bought
by at least one employer. Employees working for the employers can select at most one insurance
policy. A policy can be selected by any number of employees including zero. Employees can add
any number of dependents to their policy, including zero. A dependent can be added by only one
employee. Employees can file any number of claims including zero, and a claim must come from
only one employee. The following attributes are important:
Policy: PolicyID, PolicyName, Deductible, Premium
Employer: EmployerID, EmployerName, EmployerAddress, NoOfEmployees
Employee: EmpID, EmpName, EmpAddress, EmpEligible, EmpDOB
Dependent: DependentName, DependentRelation, DepDOB
Claim: ClaimID, ClaimDescription, ClaimAmount