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

venereology answered 1 year ago

Next > < Previous

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.

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

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 ﬁnd out more about this application, think about any experiences...

A. Rectangles B. Circles C. Diamonds D. Lines In an E-R diagram, entities are represented as:

Consider the relation R= {A, B, C, D, E, F, G, H} and the set of...

Consider the relation R= {A, B, C, D, E, F, G, H} and the set of functional dependencies: FD= {{B}—> {A}, {G}—> {D, H}, {C, H}—> {E}, {B, D}—> {F}, {D}—>{C}, {C}—> {G}} 1) Draw FD using the diagrammatic notation. 2) What are all candidate keys for R? 3) If delete {C}—>{G} and change {C, H}—> {E} to {C, H}—> {E, G}, what are all candidate keys for R

Describe a real-world business situation that could be addressed by collecting and analyzing a set of...

Describe a real-world business situation that could be addressed by collecting and analyzing a set of data using the t-test. What open source would you use to collect that data?

Subjects