Q1 Given The Following 3nf Relational Schema Regarding Art Exhibitions Location Icode Iname Iaddress Artist Ald 1 (31.13 KiB) Viewed 61 times
Q1 Given The Following 3nf Relational Schema Regarding Art Exhibitions Location Icode Iname Iaddress Artist Ald 2 (9.61 KiB) Viewed 61 times
(Q1) Given the following 3NF relational schema regarding art exhibitions LOCATION (ICode, IName, IAddress) ARTIST (alD, aName, aCountry) EXHIBITION (eCode, eName) EXHIBITIONLOCDATE (eCode, ICode, eStartDate, eEndDate) ARTOBJECT (aolD, aoName, aoType, alD) ARTEXHIBITED (eCode, ICode, aolD, boothNo) [Note: 1. Underlined attributes are primary/composite keys of the relations & italicized attributes are foreign keys. 2.1=location, a = artist, e= exhibition, ao= artObject]
(e) The exhibition name and location code of all exhibitions. (f) The location name and address of all "Voyage to ancient Egypt" exhibitions. (g) The name of all art objects exhibited at "Voyage to ancient Egypt" exhibition along with their booth number.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!