Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Last 4 digits of CWID O Problem 1 30%): You are asked to design a database for a health insurance company HICOM that satisfies the
Last 4 digits of CWID O Problem 1 30%): You are asked to design a database for a health insurance company HICOM that satisfies the following requirements: a. HICOM has several local offices. Each local office has a unique number, a unique name, an address, a manager, and a telephone number. D. HICOM has several insurance plans. Each plan has a unique code, a fixed premium, age range, sex, minimum income. Age range is composite of a minimum age and a maximum age. C. A subscriber has a unique subscriber's number, name, sex, address, telephone number. Each subscriber signs up for a specific insurance plan. A loal office handles the subscriber's paper work. Some queries access the records by the last name of the subscriber. Some queries need to refer to city, state, and/or zip code in the address. d. Each claim has a unique claim number, a date, a type of claim, and the name of the employee who processes the claim. Each claim is submitted by a subscriber and received by a local office. e. Each claim may have several follow-up records. The record has a sequence number that is unique within the claim, the date of the record and the nature of the record. Design the database using ER model. Show your design by an ER diagram. Problem 2 (30%): Given the following ER-diagram, convert it to relational model, with pr mary keys and foreign keys clearly specified. Name Addr STUDENT EnrollSECTION Grade Has Majorln DNum DEPARTMENT- Offer/ COURSE Phone CNum Units Name (Continue on the back of the paper for Problem 3)
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