if you want to remove an article from website contact us from top.

    construct an e-r diagram for a car insurance company whose customers own one or more cars each. each car has associated with it zero to any number of 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.

    Mohammed

    Guys, does anyone know the answer?

    get construct an e-r diagram for a car insurance company whose customers own one or more cars each. each car has associated with it zero to any number of 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. from screen.

    [Solved] Construct an ER diagram for a carinsurance company whose

    On StuDocu you find all the lecture notes, summaries and study guides you need to pass your exams with better grades.

    Databases 2 (proctored course)

    Anonymous Student 5 months ago

    Construct an E-R diagram for a car-insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents.

    Like 0 All replies Expert Answer 5 months ago

    Ans.A text based description of the E-R diagram is provided below:Customer(customer_id,customer_name)(1)|||Owns|||(1 or Many)Car(Car_no,Car_name,Number_of_Road_Accidents)(0 or Many)||Associated_to||||(0 or Many)Road_accidents(accident_id,accident_description)Description of entities in E-R diagram:

    There exists only 2 entities in the E-R diagram they are described below:

    Entity 1:CustomerThe customer can have following associated attributes

    1.customer_id 2.customer_name 3.customer_address 4.customer_phoneNo

    Entity 2:CarThe Car can have following associated attributes

    1.Car_no 2.Car_name

    3.Number_of_Road_Accidents

    Entity 3:Road_accidents

    **1.**Accident_id

    **2.**accident_description

    3.vechicles_involvedDescription of kind of relationship between the entities:1.Between customer and car: 1 to N

    a).Since a customer can own one or more cars hence the relationship is defined as

    “One or Many”

    b).Since each car can be only owned by only one customer hence (1) has been used at customer end.

    1.Between car and Road_accidents:N to N

    a)Since each car can have associated multiple road_accidents and an accident can involve two or more cars hence many to many relationships exist between the two entities.

    Note:

    We currently do not have a feature to support diagrams/graphs and will be updating soon. We tried to answer the question as best as possible explaining the concepts behind the question.

    Like 1

    Related Answered Questions

    Explain the major differences between two-tier and three-tier database architectures. Please share the web resources that were used to answer the pointed question. They are required for APA citation. I appreciate your support.

    11 days ago

    discuss role-based access controls (RBAC) and how they compare to other types of controls, such as label-based access controls (LBAC) Note: Please provide the resources used to address the question above. They are required for in-text citations. Thank you for your understanding

    29 days ago

    List and explain three ways in which caching can be used to speed up Web server performance. Note: Please provide the resources used to address the question above. They are required for in-text citations. thank you for your understanding

    1 month ago

    Part(2)Database systems are in use everywhere in our society. Explain the advantages of cloud computing over the traditional IT model (Table 10.1) and reference 2 additional websites.

    1 month ago

    Part(2) Mobile application development for devices such as iPhone and Android, and even tablet PCs like iPad and PlayBook, will surpass application development on other platforms.For your discussion assignment: Using the textbook and 2 of the approved websites discuss the database implications for either cloud computing or mobile application development.

    1 month ago

    स्रोत : www.studocu.com

    Construct an ER diagram for car insurance company that has a set of customers each of whom owns one or more cars. Each car has associated with it zero to any number of recorded accidents

    2 87k views

    Construct an ER diagram for car insurance company that has a set of customers each of whom owns one or more cars. Each car has associated with it zero to any number of recorded accidents

    written 6.5 years ago by

    meghalikalyankar • 1.3k

    modified 9 months ago by

    dragionro479 • 40

    database management systems

    ADD COMMENT EDIT

    2 Answers

    6 18k views

    written 6.5 years ago by

    meghalikalyankar • 1.3k

    modified 8 months ago by

    jerichocastro0324 • 30

    ADD COMMENT EDIT 1 6.5k views

    written 9 months ago by

    dragionro479 • 40

    Computer er exam mudichutu tha ponum

    ADD COMMENT EDIT

    Please log in to add an answer.

    स्रोत : www.ques10.com

    Solved Construct an E

    Answer to Solved Construct an E-R diagram for a car insurance company

    © 2003-2022 Chegg Inc. All rights reserved.

    स्रोत : www.chegg.com

    Do you want to see answer or more ?
    Mohammed 6 day ago
    4

    Guys, does anyone know the answer?

    Click For Answer