SQL Questions please!

Question w 110 points Wo comider the ERD below describing Alack in a Ibary systerit: Check all that apply. Why digd we split Book into Book and DookCopy to represent a book in a forary? All Bookis have the same ISBN and ISBN cannot be al ley for a BookCogy. A Eookcoey has add tional attributes with respect to a Book such itr its status in khe library. We want to avoid redurdancy when we transform the ERD into relations: T A BaokCopy is a physical book while a Hook captures all tho features af a book includies isbn title and pubyear. We ronsider the ERD belaw describing a flook in a library sytem: How weuld you add information about the authors of a beoK on the CRD? Add an Entity Type Avthor and a Relationstip Type Write between BookCopy and Authar Add an Entity Type Author and a Relationship Type Write between Book and sthor Add an attraute Authors to Book Add an Attribute Authars to BookCopy Question 10 (10 points) We comider an enterprise, which incluces movies, actors, and studios that produce movies. Actors are people with norinal attibutes, lise id, name, date of birth, ete. Actors play in movies A movile has the uwual attributer: t tlle, release date. director, ete. It the ERD below capturing al the information provided here? Stufios are companies. A compony has an address, phone numbers (typicaily more than one), name, the Studios have additional attributes, such as the artheb director. Constrants. A move has at least one aclor, and exsctly one studio makes each particulae movie. Every actor played in at least cne morie, Some studios may be brand new and had no time to make any movies yet. Constraints A movie has at least one actor, and exactly one studio makes each particular inovie. Every actor played in at least one movie. 50 me stucios mar be brand new and had no time to make any movier yet. Tcue Question w 110 points Wo comider the ERD below describing Alack in a Ibary systerit: Check all that apply. Why digd we split Book into Book and DookCopy to represent a book in a forary? All Bookis have the same ISBN and ISBN cannot be al ley for a BookCogy. A Eookcoey has add tional attributes with respect to a Book such itr its status in khe library. We want to avoid redurdancy when we transform the ERD into relations: T A BaokCopy is a physical book while a Hook captures all tho features af a book includies isbn title and pubyear. We ronsider the ERD belaw describing a flook in a library sytem: How weuld you add information about the authors of a beoK on the CRD? Add an Entity Type Avthor and a Relationstip Type Write between BookCopy and Authar Add an Entity Type Author and a Relationship Type Write between Book and sthor Add an attraute Authors to Book Add an Attribute Authars to BookCopy Question 10 (10 points) We comider an enterprise, which incluces movies, actors, and studios that produce movies. Actors are people with norinal attibutes, lise id, name, date of birth, ete. Actors play in movies A movile has the uwual attributer: t tlle, release date. director, ete. It the ERD below capturing al the information provided here? Stufios are companies. A compony has an address, phone numbers (typicaily more than one), name, the Studios have additional attributes, such as the artheb director. Constrants. A move has at least one aclor, and exsctly one studio makes each particulae movie. Every actor played in at least cne morie, Some studios may be brand new and had no time to make any movies yet. Constraints A movie has at least one actor, and exactly one studio makes each particular inovie. Every actor played in at least one movie. 50 me stucios mar be brand new and had no time to make any movier yet. Tcue