Question: table [ [ Customer , Address,Ordered,Amount,Priceperunit,Onhand,Vendor ] , [ Alice , 1 3 - 1 4 5 ? t h Ave,Plums, 4 0 ,
tableCustomerAddress,Ordered,Amount,Priceperunit,Onhand,VendorAlice Ave,Plums,Very FreshAlice Ave,Oranges,Garden HeavenAlicePears,Produce OneAlice Avenue,Oranges,Garden Heav.Bill Mapel Drive,Apples,Very FreshBill Maple Drive,Bananas,Garden HeavenBill Maple DrBananas,Garden HvnCaitlin Oak Road Apt. APlums,Very FreshCaitlin Oak Rd ApAPlums,V FreshElizabeth Sunshine Lane,Kiwi,Veggie HeavenLaura East Street,Grapes,Veggie HavenLaura East Street,Apples,Fresh, SECTION Use Live SQL to code the following queries
o Use SQL code to create the tables you identified sections and of this assignment.
For each table created, copypaste a screenshot showing the SQL used to create the table and the message indicating the table was created.
o Use SQL code to insert the data shown in the table into the appropriate tables.
For each table populated, copypaste a screenshot showing the SQL used to insert the data in the table.
o After inserting all the data in the various tables, use the SELECT command to show all the data in the table you created.
Copypaste a screenshot showing the SELECT command that you use to show the data in each of the tables.
o Create three reports using joins which you feel would be necessary for managerssupervisors to have in order to effectively manage the day to day business operations of this business scenario.
For each report you create, copypaste a screenshot showing the SQL used to execute the report AND the data obtained from running the SQLAnswer ASAP thank you
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
