Page 1 of 1
(Q1) Given the following 3NF relational schema regarding art exhibitions LOCATION (ICode, IName, IAddress) ARTIST (alD,
Posted: Sun Jul 10, 2022 11:31 am
by answerhappygod

- Q1 Given The Following 3nf Relational Schema Regarding Art Exhibitions Location Icode Iname Iaddress Artist Ald 1 (31.13 KiB) Viewed 63 times

- Q1 Given The Following 3nf Relational Schema Regarding Art Exhibitions Location Icode Iname Iaddress Artist Ald 2 (9.61 KiB) Viewed 63 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.