Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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). |
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. |
Use relational algebra, relational calculus and SQL to express the following query.
Find the instruments (InstID) played by any musician named 'John'
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started