Question

Suppose a database has the following three relations.
Museum (mid: integer, name: string, address: string, website: string)
Displays (museumID: integer, artID: integer, startDate: date)
ArtItem (aid: integer, title: string, weightPnd: integer, type: string)
Artist (pid: integer, firstname: string, lastname: string, birthdate: date, deathdate: date)
Creates (artistID: integer, artID: integer, year: integer)


(The "bit" data type stores 0 or 1. False or true. Booleans.)
"museumID" in Displays is a foreign key referencing "mid" in Museum.
"artistID" in Creates is a foreign key referencing "pid" in Artist. ("pid" for person identifier)
"artID" in Displays and Creates are foreign keys referencing "aid" in ArtItem.

You may assume simple boolean comparisons work on dates.

Write the following queries in relational algebra.

1. Find the first and last names of artists that created an art item titled "Mona Lisa" and also an art item titled "Vitruvian Man".
2. Find the names and addresses of museums that display art item(s) by an artist with last name "Michelangelo".

Answer 1

If you have any doubts, please give me comment...

Find the first and last names of artists that created an art item titled "Mona Lisa" and also an art item titled "Vitruvian Man".

Find the names and addresses of museums that display art item(s) by an artist with last name "Michelangelo".