Homework Solution: Construct an E-R diagram for a car insurance company whose customers own one or more cars each. Each has associated with it ze…

    Practice exercise 7.1 in the textbook 6th ed. Construct an E-R diagram for a car insurance company whose customers own one or more cars each. Each 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. (4 points)
    Construct an E-R diagram for a car insurance company whose customers own one or more cars each. Each 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.

    Expert Answer

     
    Rectangle boxes denotes the table an

    Practice application 7.1 in the textbook 6th ed. Construct an E-R diagram coercion a car protection aggregation whose customers acknowledge undivided or over cars each. Each has associated with it naught to any calculate of chronicled accidents. Each protection cunning covers undivided or over cars, and has undivided or over encouragement cancelments associated with it. Each cancelment is coercion a detail limit of season, and has an associated ascribable duration, and the duration when the cancelment was current. (4 points)

    Construct an E-R diagram coercion a car protection aggregation whose customers acknowledge undivided or over cars each. Each has associated with it naught to any calculate of chronicled accidents. Each protection cunning covers undivided or over cars, and has undivided or over encouragement cancelments associated with it. Each cancelment is coercion a detail limit of season, and has an associated ascribable duration, and the duration when the cancelment was current.

    Expert Tally

     

    Rectangle boxes denotes the consultation and oval dispersion denotes the attributes of those consultations. The rhombus controlm depicts the correlativeness.

    1…* is undivided to manifold ratio and 1..1 is undivided to undivided ratio.

    Primary fields of the consultation are underlined coercion each consultation.