Question

In: Computer Science

Create an E/R diagram for the following business situation and convert the diagram into a set...

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

Solutions

Expert Solution


Related Solutions

Construct an E-R diagram for a hospital with a set of patients and a set of...
Construct an E-R diagram for a hospital with a set of patients and a set of medical doctors. Associate with each patient a log of the various tests and examinations conducted. Use your best judgement to identify the attributes for each of those entities.
a) Construct an E-R diagram for a hospital with a set of patients and a set...
a) Construct an E-R diagram for a hospital with a set of patients and a set of medical doctors. Associate with each patient a log of the various tests and examinations conducted. b) Construct appropriate relation schemas for the E-R diagram. (ex. customer(name, birth, ID...))
Q1)   Convert the following set of BNF rules to a single EBNF rule. <E> --> <E>...
Q1)   Convert the following set of BNF rules to a single EBNF rule. <E> --> <E> + <T> | <E> - <T> | <T> Q2)   Briefly explain how the expected type and actual type of <expr>             in the following two BNF rules are determined: <assign> --> <var> = <expr> (Rule 1) <expr> --> <var> + <var> (Rule 2)
Please create a contingency diagram for the following situation: There is a pigeon in an operant...
Please create a contingency diagram for the following situation: There is a pigeon in an operant chamber. He finds a shiny metal thing and pecks it. When the pigeon pecks it, a food pellet comes out of the wall of the chamber which the pigeon eats. The pigeon continues pecking the shiny metal thing more and more.
Draw an E-R diagram for each of the following situations (if you believe that you need...
Draw an E-R diagram for each of the following situations (if you believe that you need to make additional assumptions, clearly state them for each situation): 1. A laboratory has several chemists who work on one or more projects. Chemists also may use certain kinds of equipment on each project. Attributes of CHEMIST include Employee_ID (identifier), Name, and Phone- No. Attributes of PROJECT include ProjecUD (identifier) and Start_Date. Attributes of EQUIPMENT include Serial_No and Cost. The organization wishes to record...
From the following data set, create a scatter diagram and choose a time series analysis method...
From the following data set, create a scatter diagram and choose a time series analysis method and use it to adjust them and forecast for month 13, justify because you chose the method you have chosen, you choose the parameters you need Month 1   2 3 4 5 6 7 8 9 10 11 12 13 Sales 210 190 240 250 200 170 190 235 160 185 260 145
For this step, you should draw an E-R Diagram for this dataset. To this goal, you...
For this step, you should draw an E-R Diagram for this dataset. To this goal, you should conduct the following steps: 1. Identify the entities and composite entities 2. Identify the entities’ attributes and primary key 3. Identify the relationships among the entities and between entities and composite entities 4. Specify the relationships' integrities
In this project you will be provided a set of specifications to create an entity-relationship diagram...
In this project you will be provided a set of specifications to create an entity-relationship diagram and design accompanying table layout using sound relational modeling concepts and practices. The relationships between the entities and the attributes for the entities will be identified and described. This database will provide the foundation for the follow-on project. The following paragraphs provide the background and summary of the business requirements. You are a database consultant with Premier Software, LLC and have been assigned to...
What is the Proper E/R diagram for these 5 Departments Entities that support the Volunteer management...
What is the Proper E/R diagram for these 5 Departments Entities that support the Volunteer management software: Volunteer-Details (entity) Volunteer-name (Entity) Volunteer-age(entity) Volunteer-sex (entity) Volunteers clocked in (entity) Volunteers clocked out (entity) Entities that support the Guest management software: Guest (entity) Admission (entity) Guest-name (entity) Guest-age (entity) Guest-sex (entity) Beds(entity) Shower (entity) Laundry-service (entity) Meals (entity) Basic-medical-care (entity) Emergency-services(entity) Rule-Violation (entity) Entities that support the Scheduling software: Volunteer Shifts(entity) Monday Tuesday Wednesday Thursday Friday Saturday Sunday Employee Shifts (entity) Monday...
1a. Construct (draw) an E-R diagram representing the conceptual design of the database. Be sure to...
1a. Construct (draw) an E-R diagram representing the conceptual design of the database. Be sure to identify primary keys, relationship cardinalities, etc. State any assumptions you make. 1b. Convert your E-R diagram to the relational schema. Identify the primary keys of ever relation. Consider the following application: An electronics vendor operates both a Web site and a chain of many physical stores. Examples include Best Buy and Circuit City. To find out more about this application, think about any experiences...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT