Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning VB.NET Databases

Authors: Thearon Willis

1st Edition

1594864217, 978-1594864216

More Books

Students also viewed these Databases questions