Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help create an ER diagram for the following also explain thought process if possible Your ER Diagram must contain the following: List the entities

Please help create an ER diagram for the following also explain thought process if possible image text in transcribed
Your ER Diagram must contain the following: List the entities in database and list attributes for each entity 2. 1. 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 . 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 . Vehicles has vin number, Make, Model, Year and mileage coverage Home Policy date. . Policies for house come under the Home Policy. Home Policy has a pno, policy date and a term price House 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

More Books

Students also viewed these Databases questions

Question

What is focal length? Explain with a diagram and give an example.

Answered: 1 week ago

Question

What is physics and how does it apply in daily life?

Answered: 1 week ago

Question

What is the relation of physical mathematics with examples?

Answered: 1 week ago