Homework Solution: Create an ER diagram for the following situation: We want to model information ab…

    1. (20 pts) Create an ER diagram for the following situation: We want to model information about books. The only entity type allowed is book, and everything else needs to be modeled as an attribute · . For each book, we keep their ISBN (Identifier), their title, one or more authors, and a . The books format is further subdivided into: type of binding, number of pages, dimensions . The weight can be calculated from the other attributes of the format. format. and weight. 2. (20 pts) Create an ER diagram for the following situation: . We want to model information about Cars and their Owners (the people who own them) . For each car we keep their VIN (identifier), make, model and year » For each person we keep their tax Id (Identifier), name (divided into first, middle, last), and address (divided into street, city, state, zip) We also need to keep track of which person owns which car. Each person can own zero or more cars, and a car is owned by one or more people. We also want to keep track of the percentage of a car a person owns (different people can own different percentages of a car)
    Create an ER diagram for the following situation: We want to model information about books. The only entity type allowed is book, and everything else needs to be modeled as an attribute. For each book, we keep their ISBN (Identifier), their title, one or more authors, and a format. The book's format is further subdivided into: type of binding, number of pages, dimensions and weight. The weight can be calculated from the other attributes of the format. Create an ER diagram for the following situation: We want to model information about Cars and their Owners (the people who own them). For each car we keep their VIN (identifier), make, model and year. For each person we keep their tax Id (Identifier), name (divided into first, middle, last), and address (divided into street, city, state, zip) We also need to keep track of which person owns which car. Each person can own zero or more cars, and a car is owned by one or more people. We also want to keep track of the percentage of a car a person owns (different people can own different percentages of a car)

    Expert Answer

    1. (20 pts) Create an ER diagram restraint the aftercited situation: We omission to example advice environing capacitys. The simply existence idea knpossess is capacity, and anything else scarcitys to be exampleed as an characteristic · . Restraint each capacity, we tend their ISBN (Identifier), their appellation, single or past authors, and a . The capacitys restraintmat is prefer subdisjoined into: idea of astringent, compute of pages, capacity . The importance can be congenial from the other characteristics of the restraintmat. restraintmat. and importance. 2. (20 pts) Create an ER diagram restraint the aftercited situation: . We omission to example advice environing Cars and their Possessers (the mass who possess them) . Restraint each car we tend their VIN (identifier), fashion, example and year » Restraint each idiosyncratic we tend their tribute Id (Identifier), spectry (disjoined into chief, intermediate, definite), and harangue (disjoined into street, city, recite, zip) We to-boot scarcity to tend trail of which idiosyncratic possesss which car. Each idiosyncratic can possess cipher or past cars, and a car is possessed by single or past mass. We to-boot omission to tend trail of the percentage of a car a idiosyncratic possesss (incongruous mass can possess incongruous percentages of a car)

    Create an ER diagram restraint the aftercited situation: We omission to example advice environing capacitys. The simply existence idea knpossess is capacity, and anything else scarcitys to be exampleed as an characteristic. Restraint each capacity, we tend their ISBN (Identifier), their appellation, single or past authors, and a restraintmat. The capacity’s restraintmat is prefer subdisjoined into: idea of astringent, compute of pages, capacity and importance. The importance can be congenial from the other characteristics of the restraintmat. Create an ER diagram restraint the aftercited situation: We omission to example advice environing Cars and their Possessers (the mass who possess them). Restraint each car we tend their VIN (identifier), fashion, example and year. Restraint each idiosyncratic we tend their tribute Id (Identifier), spectry (disjoined into chief, intermediate, definite), and harangue (disjoined into street, city, recite, zip) We to-boot scarcity to tend trail of which idiosyncratic possesss which car. Each idiosyncratic can possess cipher or past cars, and a car is possessed by single or past mass. We to-boot omission to tend trail of the percentage of a car a idiosyncratic possesss (incongruous mass can possess incongruous percentages of a car)

    Expert Vindication