Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help already answered it but need another style or way to created this ER diagram Your task: You must design a database(ie Create an

Please help already answered it but need another style or way to created this ER diagram image text in transcribed
Your task: You must design a database(ie Create an ER diagram) for FIT Insurance company and you must explain your thought process when creating this diagram. Your ER Diagram must be handwritten. On a seperate page write all entities and there is a key attribute Your ER Diagram must contain the following: 1. List the entities in database and list attributes for each entity 2. You need to draw the ER Diagram, Show attributes(key attribute, regular attribute or multi value attribute etc) and the entities(Entity or weak entity) 3. Show the relationship(s) between the entities (remember diamond shows the relationship) 4. What are the relationships between the entities(Table, Object) have with each other 1:1 1:M, M:N 5. Is there generation or specialization with these entities if so it must be shown in the ER diagram " In a separate page you must explain your thought process of this ER Diagram. Why are these the entities, the attributes, relationship and why you chose 1:1, 1:M and M:N are there relationship type. Where did generation or specialization occur if any occurred. Scenario: Your designing a database for Fit Insurance company. Assume that following are the requirements that were collected: Fit Insurance Company has different policies. The policies have pno, term_ price and coverage . Policies are categorized based on their types. We have 2 types Auto_Policy and a . Policies for vehicles come under Auto_Policy. Auto_Policy has a pno, vehicle type and issue . Policies for house come under the Home_Policy. Home_Policy has a pno, policy date and a . House has number and name Home_Policy. Policies pno, coverage and price date. Vehicles has vin number , Make, Model, Year and mileage term price A Customer can take policies through a policy agent. The customer has a name an number, address, email address and a contact number. A customer can only policy take only

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

Concepts of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

7th edition

978-1111825911, 1111825912, 978-1133684374, 1133684378, 978-111182591

More Books

Students also viewed these Databases questions

Question

7-2 What are the different types of networks?

Answered: 1 week ago