Question: 1. Build an E-R for problem and transform it into a relational data model. User: main attributes: SSN, name, gender, date of birth, address, income,

 1. Build an E-R for problem and transform it into a

1. Build an E-R for problem and transform it into a relational data model. User: main attributes: SSN, name, gender, date of birth, address, income, MedHistorv-is multi-value attribute Insurance comp: main attributes: ID, name, address, contact Health Plan: main attributes: premium, deductible, copay, description; Claim Num: main attributes: ID, date of services, status, healthcare provider, bill amount, out-of-pocket amount. (a) Users purchase healthcare plans offered by the insurance companies. The following information is recorded when a patient purchases a health plan: transaction ID, date, amount charged, amount paid; (b) Users visit a healthcare provider, the healthcare provider sends the user's bill amount to the Insurance company claim center. A claim is associated with the user and healthcare plan (la). Use this information to build an E-R model. Mark the max. and min. cardinalities. (lb). Transform the E-R diagram to a relational data model. Identify the primary and foreign keys for each relation

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!