Relational Databases

Consider the following relation schemas of a music store database.

Relation Schemas Meaning and additional information

Musicians(ssn, name, annualIncome) Registers the ssn of musicians and
their names and annual incomes.

Instruments(instrID, iname, key) Registers instruments.

Plays(ssn, instrID) Registers which musicians play which instruments

SongsAppears(songID, authorSSN, title, albumIdentifier) Registers songs
and which albums they appear. Every song must have exactly one author
who is a musician, and appears in exactly one album.

Lives(ssn, address, phone) Registers where musicians live and which
phones they use.

Place(address, otherInfo) Register all addresses.

Perform(songID, ssn) Register which songs are performed by which
musicians

AlbumProducer(ssn, albumIdentifier, copyrightDate, speed, title)
Registers albums and their producers (who are musicians).

Formulate relational algebra queries to find the following information.
Note that primary keys are underlined in the table above.

Musician(s) ssn(s) who play 'Saxophone'.

Musicians' names who share the same address. (Assume each musician has
only one address)

Album(s) title(s) produced by musician named 'Richard'.

Musician(s) name(s) who play all instruments played by 'Richard'.

Titles of albums produced by musicians who play 'guitar' and 'piano'.