Page 1 of 1
(Q1) Given the following 3NF relational schema regarding art exhibitions LOCATION (ICode, IName, IAddress) ARTIST (alD,
Posted: Tue Jul 12, 2022 8:06 am
by answerhappygod
- Q1 Given The Following 3nf Relational Schema Regarding Art Exhibitions Location Icode Iname Iaddress Artist Ald 1 (46.42 KiB) Viewed 41 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] Write the relational algebra expression to extract the following: (a) The name of artists and their countries (b) The exhibition code and location code of all exhibitions along with their duration. (c) The name of all Italian artists. (d) The exhibition code of all exhibitions which started in the month of April this year.