Question: Based on the tables given write an SQl query to retrieve the first and last name of the musicians along with the instruments they played,

Based on the tables given write an SQl query to retrieve the first and last name of the musicians along with the instruments they played, for May 4, 1959 recording of the composition titled "Big One"

Based on the tables given write an SQl query to retrieve the

first and last name of the musicians along with the instruments they

played, for May 4, 1959 recording of the composition titled "Big One"

CREATE TABLE label / lbltitle VARCHAR (40), lblstreet VARCHAR (50), lblcity VARCHAR(30), lblstate VARCHAR (15), lblpostcode VARCHAR(12), lblnation VARCHAR(30), PRIMARY KEY (lbltitle)); CREATE TABLE cd cdid INTEGER, cdlblid VARCHAR(30), cdtitle VARCHAR(30), cdyear INTEGER, lbltitle VARCHAR (40), PRIMARY KEY (cdid). FOREIGN KEY (lbltitle) REFERENCES label (lbltitle)); CREATE TABLE composition compid INTEGER, comptitle VARCHAR(40), compyear INTEGER, PRIMARY KEY (compid)); CREATE TABLE recording rcdid INTEGER, rcdlength INTEGER, reddate DATE, compid INTEGER, PRIMARY KEY (rcdid, compid), FOREIGN KEY (compid) REFERENCES composition (compid)); CREATE TABLE track cdid INTEGER, trknum INTEGER, rcdid INTER CREATE TABLE recording ( rcdid INTEGER, rcdlength INTEGER, rcddate DATE, compid INTEGER, PRIMARY KEY (rcdid, compid), FOREIGN KEY (compid) REFERENCES composition (compid)) CREATE TABLE track cdid INTEGER, trknum INTEGER, rcdid INTEGER, compid INTEGER, PRIMARY KEY (trknum, cdid), EOREIGN KEY (cdid) REFERENCES cd (cdid), FOREIGN KEY (rcdid, compid) REFERENCES recording (rcdid, compid)): CREATE TABLE person panid INTEGER, psnfname VARCHAR(40), psnlname VARCHAR (40). PRIMARY KEY (psnid)); CREATE TABLE person_recording psnrcdrole VARCHAR (25), panid INTEGER, compid INTEGER rcdid INTEGER, PRIMARY KEY (psnredrole, ponid, compid, redid), FOREIGN KEY (psnid) REFERENCES person (panid), FOREIGN KEY (rcdid, compid) REFERENCES recording (rcdid, compid)): CREATE TABLE psnfname VARCHAR (40), psnlname VARCHAR(40), PRIMARY KEY (psnid)); CREATE TABLE person_recording psnrcdrole VARCHAR (25), psnid INTEGER, compid INTEGER, rcdid INTEGER, PRIMARY KEY (panrcdrole, panid, compid, rcdid), FOREIGN KEY (psnid) REFERENCES person (psnid), FOREIGN KEY (rcdid, compid) REFERENCES recording (rcdid, compid)); CREATE TABLE person composition psncomprole VARCHAR(40), psncomporder INTEGER, psnid INTEGER, compid INTEGER, PRIMARY KEY (psncomprole, psnid, compid), FOREIGN KEY (psnid) REEERENCES person (psnid), FOREIGN KEY (compid) REFERENCES composition (compid)); CREATE TABLE person_cd pancdorder INTEGER, psnid INTEGER cdid INTEGER, PRIMARY KEY (psnid, cdid), FOREIGN KEY (psnid) REFERENCES person (panid), FOREIGN KEY (coid) REFERENCES cd (cdid)); CREATE TABLE label / lbltitle VARCHAR (40), lblstreet VARCHAR (50), lblcity VARCHAR(30), lblstate VARCHAR (15), lblpostcode VARCHAR(12), lblnation VARCHAR(30), PRIMARY KEY (lbltitle)); CREATE TABLE cd cdid INTEGER, cdlblid VARCHAR(30), cdtitle VARCHAR(30), cdyear INTEGER, lbltitle VARCHAR (40), PRIMARY KEY (cdid). FOREIGN KEY (lbltitle) REFERENCES label (lbltitle)); CREATE TABLE composition compid INTEGER, comptitle VARCHAR(40), compyear INTEGER, PRIMARY KEY (compid)); CREATE TABLE recording rcdid INTEGER, rcdlength INTEGER, reddate DATE, compid INTEGER, PRIMARY KEY (rcdid, compid), FOREIGN KEY (compid) REFERENCES composition (compid)); CREATE TABLE track cdid INTEGER, trknum INTEGER, rcdid INTER CREATE TABLE recording ( rcdid INTEGER, rcdlength INTEGER, rcddate DATE, compid INTEGER, PRIMARY KEY (rcdid, compid), FOREIGN KEY (compid) REFERENCES composition (compid)) CREATE TABLE track cdid INTEGER, trknum INTEGER, rcdid INTEGER, compid INTEGER, PRIMARY KEY (trknum, cdid), EOREIGN KEY (cdid) REFERENCES cd (cdid), FOREIGN KEY (rcdid, compid) REFERENCES recording (rcdid, compid)): CREATE TABLE person panid INTEGER, psnfname VARCHAR(40), psnlname VARCHAR (40). PRIMARY KEY (psnid)); CREATE TABLE person_recording psnrcdrole VARCHAR (25), panid INTEGER, compid INTEGER rcdid INTEGER, PRIMARY KEY (psnredrole, ponid, compid, redid), FOREIGN KEY (psnid) REFERENCES person (panid), FOREIGN KEY (rcdid, compid) REFERENCES recording (rcdid, compid)): CREATE TABLE psnfname VARCHAR (40), psnlname VARCHAR(40), PRIMARY KEY (psnid)); CREATE TABLE person_recording psnrcdrole VARCHAR (25), psnid INTEGER, compid INTEGER, rcdid INTEGER, PRIMARY KEY (panrcdrole, panid, compid, rcdid), FOREIGN KEY (psnid) REFERENCES person (psnid), FOREIGN KEY (rcdid, compid) REFERENCES recording (rcdid, compid)); CREATE TABLE person composition psncomprole VARCHAR(40), psncomporder INTEGER, psnid INTEGER, compid INTEGER, PRIMARY KEY (psncomprole, psnid, compid), FOREIGN KEY (psnid) REEERENCES person (psnid), FOREIGN KEY (compid) REFERENCES composition (compid)); CREATE TABLE person_cd pancdorder INTEGER, psnid INTEGER cdid INTEGER, PRIMARY KEY (psnid, cdid), FOREIGN KEY (psnid) REFERENCES person (panid), FOREIGN KEY (coid) REFERENCES cd (cdid))

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!