(Q1) Given the following 3NF relational schema regarding art exhibitions LOCATION (ICode, IName, IAddress) ARTIST (alD,

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
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,

Post by answerhappygod »

Q1 Given The Following 3nf Relational Schema Regarding Art Exhibitions Location Icode Iname Iaddress Artist Ald 1
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, 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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply