[go: up one dir, main page]
Scribd
Upload
2K views1 page

In A ER Diagram A Car Insurance Company Consists of Three Objects: Customer Policy Car

The document describes an entity relationship (ER) diagram for a car insurance company with customers who own one or more cars. Each car can be associated with zero or more recorded accidents. Insurance policies cover one or more cars and have one or more premium payments associated with each payment having a due date and receipt date. The ER diagram models customers, policies, cars, and their relationships where customers are associated with policies and cars, policies cover cars, and cars can be associated with accidents.

Uploaded by

Vivek CHOWDARY
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2K views1 page

In A ER Diagram A Car Insurance Company Consists of Three Objects: Customer Policy Car

The document describes an entity relationship (ER) diagram for a car insurance company with customers who own one or more cars. Each car can be associated with zero or more recorded accidents. Insurance policies cover one or more cars and have one or more premium payments associated with each payment having a due date and receipt date. The ER diagram models customers, policies, cars, and their relationships where customers are associated with policies and cars, policies cover cars, and cars can be associated with accidents.

Uploaded by

Vivek CHOWDARY
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

1.

Construct an ER diagram for a car insurance company whose customers own one or
more cars each. Each car has associate with it zero to any number recorded accidents.
Each insurance policy covers one or more cars , and has one or more premium payments
associated with it . Each payment is for a particular period of time , and has an associated
due date , and the date when the payment was received.

In a ER diagram a car insurance company consists of three objects:

 Customer
 Policy
 Car
 The Entity customer consists of three attributes ID, Name, Address.
 The Entity of the customer consists of 3 relationships to the policy and licence and car.
 In the customer attributes includes customer ID Name, Address details of the customer.
 In the car entity consists of four attributes i.e car lcennse and colour of entity, year and model of
the car.
 It has relation as happenining of accident and owning of object.
 Policy is one entity and have two attribute of relation ship of buying the object.

You might also like