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.

Musicians (ssn) performed song with songID 544 or produced an album that
contains that song.

Album(s) identifier(s) with the highest speed.

Songs IDs that are not performed by any musician.

Songs titles performed by musician who have produced at least two
albums.

Musicians names with annual income more than $50,000 and have not
produced any album.