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 drill 7.1 in the textbook 6th ed. Construct an E-R diagram restraint a car protection assembly whose customers confess individual or over cars each. Each has associated with it nothing to any compute of chronicled accidents. Each protection device covers individual or over cars, and has individual or over encouragement reimbursements associated with it. Each reimbursement is restraint a detail age of opportunity, and has an associated ascribable spell, and the spell when the reimbursement was common. (4 points)

    Construct an E-R diagram restraint a car protection assembly whose customers confess individual or over cars each. Each has associated with it nothing to any compute of chronicled accidents. Each protection device covers individual or over cars, and has individual or over encouragement reimbursements associated with it. Each reimbursement is restraint a detail age of opportunity, and has an associated ascribable spell, and the spell when the reimbursement was common.

    Expert Counter-argument

     

    Rectangle boxes denotes the board and oval dissipation denotes the attributes of those boards. The rhombus emblem depicts the analogy.

    1…* is individual to multifarious relative and 1..1 is individual to individual relative.

    Primary fields of the board are underlined restraint each board.