Question: Using a record store example. Please define a database that consists of two tables to hold all of the data. One of the table should

Using a record store example. Please define a database that consists of two tables to hold all of the data. One of the table should be just for the artist Include a new artist (The Bee Gees) with no Records, CDs or Singles in our inventory Using SQL and JOINs, show the results from All of the product we have in inventory that is priced less than $20 Update the prices of all of the albums to $25.99 and re-run this query All of the CDs and Albums we have in Stock All of the Artists for which we have no inventory listed (not zero quantity, we just never had any of their material in our store in the past) The SQL queries should list the Artist, the Name of the material (cd, single or album name) and the quantity in stock Please recreate the record store problem using two tables One of those tables should be an Artist table the represents the recording artist. Please create a word document that contains your SQL and step-by-step process (be sure to show output from your selects as well as table describes, etc) Using the record store example from last time. Please define a database that consists of two tables to hold all of the data. One of the table should be just for the artist Note: Include a new artist (The Bee Gees) with no Records, CDs or Singles in our inventory Also Using SQL and JOINs, show the results from: All of the product we have in inventory that is priced less than $20 Update the prices of all of the albums to $25.99 and re-run this query All of the CDs and Albums we have in Stock All of the Artists for which we have no inventory listed (not zero quantity, we just never had any of their material in our store in the past) (The SQL queries should list the Artist, the Name of the material (cd, single or album name) and the quantity in stock )

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!