I am re-uploading the question . The first image is what I currently have . I did 1-5 but for 6 and 7 I have a little bit of issue Product| Supplier+----Customer| ProductQuantity | Date Ordered | Order Statusbrown, red and wild rice medleyorganic quinoablack beluga lentilsAjinomoto Foods North AmericaAjinomoto Foods North AmericaAjinomoto Foods North AmericaAjinomoto Foods North AmericaSteakhouse Broccoli and Cauliflower Gratin | Ajinomoto Foods North America+----+------------------------+2 | 2021-03-124 | 2021-03-126 2021-03-124 | 2021-03-124 |10 | 2021-03-12Bradlee Esparzachocolate croissantNew orderBradlee Esparza | tiramisu classicobroccoli floretsorganic quinoaGround BisonNew order| New order| New order| New orderMichelle Ramirez6Green BeansMichelle RamirezNico Prince2021-03-12AppetizersUSAAppetizersUSAAppetizersUSAAppetizersUSAAppetizersUSAAppetizersUSAAscot Valley FoodsAscot Valley FoodsAscot Valley FoodsAscot Valley FoodsAscot Valley FoodsCulinary Specialties, IncCulinary Specialties, IncCulinary Specialties, Inc| Culinary Specialties, IncCulinary Specialties, Inc| Diversified Foods and Seasonings LLCDiversified Foods and Seasonings LLC| Diversified Foods and Seasonings LLC| Diversified Foods and Seasonings LLC| Diversified Foods and Seasonings LLCDutt and Wagner of Virginia, IncDutt and Wagner of Virginia, IncDutt and Wagner of Virginia, IncDutt and Wagner of Virginia, IncDutt and Wagner of Virginia, IncJohn E. Koerner Company| John E. Koerner Company| John E. Koerner CompanyJohn E. Koerner CompanyJohn E. Koerner CompanyKellogg NA CompanyKellogg NA Company| Kellogg NA CompanyKellogg NA CompanyKellogg NA CompanyKellogg NA CompanyMonogram Foods| Monogram Foods| Monogram FoodsMonogram FoodsMonogram FoodsNew Direction Foodsbrioche burger bunsNico PrinceNew order| New order| New orderNew orderGreen Beansciabatta sandwich 6 inchlamb shank in rosemary and mint saucecoquina clamsPotatoes au Gratin| red shrimp from argentina XLJordana Beck42021-03-12mini blinisPepper Jack Risotto CakesHarvest Rice PilafMini Baguettes with Garlic Butterfrangipane king cakechocolate croissant6 | 2021-03-123 | 2021-03-128| 2021-03-12Dane KaiserGrover SquiresJavan RennieNew order+-----10 rows in set (e.00 sec)Figure 1Ast Case 1tiramisu classicoBrussels Sprouts with Bacon & ShallotsSteakhouse Creamed Corn-------------..--------- ------------------coquina clamsextra fine french peasSupplier| Product| Quantity | Date Ordered | Order Status--------------.- ---------..-+-----------..-+--------------+New Direction FoodsNew Direction FoodsDutt and Wagner of Virginia, IncAjinomoto Foods North AmericaKellogg NA CompanyKellogg NA CompanyMonogram FoodsDutt and Wagner of Virginia, IncCulinary Specialties, IncJohn E. Koerner Companylamb shank in rosemary and mint sauceveal osso bucocooked small octopus tentaclesblack beluga lentilscappuccino piered berry cheesecakeGround Bison10 | 2021-03-1215 | 2021-03-1215 | 2021-03-1212 2021-03-1220| 2021-03-1218| 2021-03-1210| 2021-03-1215 | 2021-03-1214 | 2021-03-1210| 2021-03-12New orderNew orderartichoke bottomsBreaded Pork TenderloinNew orderLemon Dill Salmon FilletsNew orderfamily size whipped sweet potatoespotatoes au gratinjasmine riceGourmet Crab CakesNew orderNew order| New orderSpiral Sliced HamKing Crab LegsLemon Dill Salmon FilletsNew orderNew orderNew orderCold Water Lobster Tails+------------- ------.------------+------------medium wild langoustinescooked small octopus tentaclesred shrimp from argentina XLTurkey BurgersSpiral Sliced Hamvery find yellow wax beansbroccoli florets10 rows in set (0.01 sec)family size smashed red potatoesChilean Sea BassKing Crab Legsauthentic french creme bruleecappuccino piered berry cheesecakeRoasted Vegetable MedleyAsparagus Spears With Hollandaise SaucePotatoes au Gratinbraveheart angus beef flank steakboneless chicken breastsbacon-wrapped pork chopsGround BisonHome-Style Roasted Turkey Breastlamb shank in rosemary and mint sauceveal osso bucoNew Direction Foodsbraveheart angus beef boneless short ribButcher's Cut Filet MignonButcher's Cut Top SirloinT-Bone SteakNew Direction FoodsNew Direction FoodsNew Direction Foods| New Direction Foods mysql> SELECT * FROM PURCHASEORDER;Times New Roman- 12| IDsupplierIdproductIdquantityorderDatei orderStateIdI U v abx A==== E-х,EditingCreate and Share RequestSignaturesStylesDictateSensitivityEditorA - I. AA A°2021-03-182021-03-182021-03-182021-03-182021-03-182021-03-182021-03-182021-03-182021-03-182021-03-185Aa vAdobe PDFParagraphA Styles aFontAdobe AcrobatVoiceSensitivityEditor8262734ks4139105iery Description1. Change to use the database frozenfood2. Insert into table productSupplier the data in file productSupplier.sg!3. Insert into table customerOrder the data in file customerOrder.sql4. Insert into table purchaseOrder the data in file purchaseOrder.sql5. Execute the SQL join query in file testCaselCode.sql6. Write a SQL join query to do the following10 rows in set (0.00 sec)mysql> SELECT * FROM CUSTOMERORDER;| IDcustomerIdproductIdquantityorderDate| orderStateId5656707048482021-03-182021-03-182021-03-182021-03-182021-03-182021-03-182021-03-182021-03-182021-03-182021-03-1814203444655210a. Select product description from table product as Productb. Select supplier name from table supplier as Supplierc. Join tables product, supplier and productSupplierd. Order by supplier name9510910 rows in set (0.00 sec)mysql> SELECT * FROM PURCHASEORDER;| IDsupplierId | productIdquantityorderDateorderStateId |7. Write a SQL join query to do the following2021-03-182021-03-18 |2021-03-18 |2021-03-18 !2021-03-18 j2021-03-18!2021-03-18 |2021-03-182021-03-18 j5a. Select supplier name from table supplier as Supplierb. Select product description from table product as Productc. Select quantity from table purchaseOrder as Quantityd. Select order date from table purchaseOrder as Date OrderedSelect state from table orderState as OrderStatusf. Join tables product, supplier, purchaseOrder and orderState28374139595е.102021-03-1810CO 00 cOc)

6. a)SELECT DESCRIPTION AS PRODUCT FROM PRODUCT; b)SELECT NAME AS SUPPLIER FROM SUPPLIER; c) SELECT…

Supplier ---- - Ajinomoto Foods North America | Ajinomoto Foods North America Ajinomoto Foods North America Ajinomoto Foods North America Ajinomoto Foods North America AppetizersUSA AppetizersUSA AppetizersUSA AppetizersUSA AppetizersUSA AppetizersUSA Ascot Valley Foods Ascot Valley Foods Ascot Valley Foods + ---------+---------- Product ---+----------+--------------+-------------- | Product | Quantity | Date Ordered | Order Status | --- . brown, red and wild rice medley organic quinoa black beluga lentils Customer +------....--------+------------ Bradlee Esparza Bradlee Esparza Michelle Ramirez 2| 2021-03-12 4 2021-e3-12 chocolate croissant New order tiramisu classico broccoli florets New order 6| 2021-03-12 New order Green Beans organic quinoa Ground Bison | Green Beans lamb shank in rosemary and mint sauce | coquina clams Potatoes au Gratin Michelle Ramirez | Nico Prince Nico Prince 4 2021-03-12 New order Steakhouse Broccoli and Cauliflower Gratin 4| 2021-03-12 New order brioche burger buns ciabatta sandwich 6 inch mini blinis Pepper Jack Risotto Cakes Harvest Rice Pilaf Mini Baguettes with Garlic Butter frangipane king cake chocolate croissant 10 2021-03-12 New order Jordana Beck | New order 4 2021-03-12 6 | 2021-03-12 3| 2021-03-12 8| 2021-03-12 Dane Kaiser New order Grover Squires Javan Rennie New order | red shrimp from argentina XL New order +-**- ...... ----- 10 rows in set (e.00 sec) Figure 1st Case 1 tiramisu classico

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE