Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 ra 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 Home_Policy. Policies pno, coverage and price Policies for vehicles come under Auto_Policy. Auto_Policy has a pno, vehicle type and issue date Vehicles has vin number, Make, Model, Year and mileage Policies for house come under the Home_Policy. Home_Policy has a pno, policy date and a term price . . . . . . Ho use has number and name A Customer can take policies through a policy agent. The customer has a name and id number, address, email address and a contact number. A customer can only take only policy

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

Database Design And Relational Theory Normal Forms And All That Jazz

Authors: Chris Date

1st Edition

1449328016, 978-1449328016

More Books

Students also viewed these Databases questions