Question: table [ [ Customer , Address,Ordered,Amount,Priceperunit,Onhand,Vendor ] , [ Alice , 1 3 - 1 4 5 ? t h Ave,Plums, 4 0 ,

\table[[Customer,Address,Ordered,Amount,Priceperunit,Onhand,Vendor],[Alice,13-145?th Ave,Plums,40,1,100,Very Fresh],[Alice,13145th Ave,Oranges,30,3,300,Garden Heaven],[Alice,13-145thAve,Pears,10,4,400,Produce One],[Alice,13145th Avenue,Oranges,40,3,300,Garden Heav.],[Bill,55 Mapel Drive,Apples,50,2,200,Very Fresh],[Bill,55 Maple Drive,Bananas,100,5,500,Garden Heaven],[Bill,55 Maple Dr.,Bananas,100,5,500,Garden Hvn.],[Caitlin,1 Oak Road Apt. 3A,Plums,40,1,100,Very Fresh],[Caitlin,1 Oak Rd. Ap.3A,Plums,40,1,100,V. Fresh],[Elizabeth,16 Sunshine Lane,Kiwi,30,7,600,Veggie Heaven],[Laura,66 East 4?th Street,Grapes,60,6,200,Veggie Haven],[Laura,66 East 4?th Street,Apples,10,2,Fresh,]] SECTION 3 Use Live SQL to code the following queries
o Use SQL code to create the tables you identified sections 1 and 2 of this assignment.
For each table created, copy/paste 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, copy/paste 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.
Copy/paste 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 managers/supervisors to have in order to effectively manage the day to day business operations of this business scenario.
For each report you create, copy/paste a screenshot showing the SQL used to execute the report AND the data obtained from running the SQL.Answer ASAP thank you
 \table[[Customer,Address,Ordered,Amount,Priceperunit,Onhand,Vendor],[Alice,13-145?th Ave,Plums,40,1,100,Very Fresh],[Alice,13145th Ave,Oranges,30,3,300,Garden Heaven],[Alice,13-145thAve,Pears,10,4,400,Produce One],[Alice,13145th Avenue,Oranges,40,3,300,Garden Heav.],[Bill,55 Mapel Drive,Apples,50,2,200,Very Fresh],[Bill,55

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!