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 control the cethcoming situation: We shortness to mould counsel encircling bodys. The singly existence likeness knconfess is body, and anything else insufficiencys to be moulded as an manifestation · . Control each body, we adhere-to their ISBN (Identifier), their denomination, individual or elevate authors, and a . The bodys controlmat is elevate subdisjoined into: likeness of stringent, calculate of pages, book . The power can be conducive from the other manifestations of the controlmat. controlmat. and power. 2. (20 pts) Create an ER diagram control the cethcoming situation: . We shortness to mould counsel encircling Cars and their Confessers (the commonalty who confess them) . Control each car we adhere-to their VIN (identifier), frame, mould and year » Control each idiosyncratic we adhere-to their rate Id (Identifier), designate (disjoined into earliest, average, decisive), and oration (disjoined into street, city, say, zip) We to-boot insufficiency to adhere-to trace of which idiosyncratic confesss which car. Each idiosyncratic can confess naught or elevate cars, and a car is confessed by individual or elevate commonalty. We to-boot shortness to adhere-to trace of the percentage of a car a idiosyncratic confesss (irrelative commonalty can confess irrelative percentages of a car)

    Create an ER diagram control the cethcoming situation: We shortness to mould counsel encircling bodys. The singly existence likeness knconfess is body, and anything else insufficiencys to be moulded as an manifestation. Control each body, we adhere-to their ISBN (Identifier), their denomination, individual or elevate authors, and a controlmat. The body’s controlmat is elevate subdisjoined into: likeness of stringent, calculate of pages, book and power. The power can be conducive from the other manifestations of the controlmat. Create an ER diagram control the cethcoming situation: We shortness to mould counsel encircling Cars and their Confessers (the commonalty who confess them). Control each car we adhere-to their VIN (identifier), frame, mould and year. Control each idiosyncratic we adhere-to their rate Id (Identifier), designate (disjoined into earliest, average, decisive), and oration (disjoined into street, city, say, zip) We to-boot insufficiency to adhere-to trace of which idiosyncratic confesss which car. Each idiosyncratic can confess naught or elevate cars, and a car is confessed by individual or elevate commonalty. We to-boot shortness to adhere-to trace of the percentage of a car a idiosyncratic confesss (irrelative commonalty can confess irrelative percentages of a car)

    Expert Retort