- Q1 Given The Following 3nf Relational Schema Regarding Art Exhibitions Location Icode Iname Iaddress Artist Ald 1 (46.42 KiB) Viewed 40 times
(Q1) Given the following 3NF relational schema regarding art exhibitions LOCATION (ICode, IName, IAddress) ARTIST (alD,
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
(Q1) Given the following 3NF relational schema regarding art exhibitions LOCATION (ICode, IName, IAddress) ARTIST (alD,
(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.