Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started