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 ce the aftercited situation: We lack to design advice environing bodys. The singly being idea recognized is body, and anything else insufficiencys to be designed as an quality · . Ce each body, we practise their ISBN (Identifier), their appellation, single or over authors, and a . The bodys cemat is aid subdisjoined into: idea of restraining, reckon of pages, body . The consequence can be adapted from the other qualitys of the cemat. cemat. and consequence. 2. (20 pts) Create an ER diagram ce the aftercited situation: . We lack to design advice environing Cars and their Avowers (the tribe who avow them) . Ce each car we practise their VIN (identifier), bring-about, design and year » Ce each idiosyncratic we practise their duty Id (Identifier), call (disjoined into pristine, average, ultimate), and discourse (disjoined into street, city, avow, zip) We as-well insufficiency to practise trail of which idiosyncratic avows which car. Each idiosyncratic can avow naught or over cars, and a car is avowed by single or over tribe. We as-well lack to practise trail of the percentage of a car a idiosyncratic avows (incongruous tribe can avow incongruous percentages of a car)

    Create an ER diagram ce the aftercited situation: We lack to design advice environing bodys. The singly being idea recognized is body, and anything else insufficiencys to be designed as an quality. Ce each body, we practise their ISBN (Identifier), their appellation, single or over authors, and a cemat. The body’s cemat is aid subdisjoined into: idea of restraining, reckon of pages, body and consequence. The consequence can be adapted from the other qualitys of the cemat. Create an ER diagram ce the aftercited situation: We lack to design advice environing Cars and their Avowers (the tribe who avow them). Ce each car we practise their VIN (identifier), bring-about, design and year. Ce each idiosyncratic we practise their duty Id (Identifier), call (disjoined into pristine, average, ultimate), and discourse (disjoined into street, city, avow, zip) We as-well insufficiency to practise trail of which idiosyncratic avows which car. Each idiosyncratic can avow naught or over cars, and a car is avowed by single or over tribe. We as-well lack to practise trail of the percentage of a car a idiosyncratic avows (incongruous tribe can avow incongruous percentages of a car)

    Expert Solution