Q1) Giving the following tables (supplies, catalog, and part). For each part, show the query and demonstrate that it works correctly on the modified sample Parts/Suppliers/Catalog table insert into suppliers (sid, sname, address) values (6. 'OnlyGreen'. "GreenOnly"); insert into catalog (sid, pid, cost) values (6. 9. 20.0): The Parts lists the colors with capital letters: so, your queries involving green or red need to use Red or Green, respectively. Selected subparts: (5). (8). (10): SUPLLIES 1, Acme Widget Suppliers,"1 Grub St., Potemkin Village, IL 61801" 2,Big Red Tool and Die,"4 My Way, Bermuda Shorts, OR 90305" 3, Perfunctory Parts, "99999 Short Pier, Terra Del Fuego, TX 41299" 4, Alien Aircaft Inc., "2 Groom Lake, Rachel, NV 51902" Catalog 1, 3,0.50 1,4,0.50 1,8,11.70 2, 3,0.55 2,8,7.95 2,1,16.50 3, 8, 12.50 3,9,1.00 4,5,2.20 4,6,1247548.23 4,7,1247548.23 Parts 1, Left Handed Bacon Stretcher Cover, Red 2, Smoke Shifter End, Black 3, Acme Widget Washer, Red 4,Acme Widget Washer, Silver 5, I Brake for Crop Circles Sticker, Translucent 6, Anti-Gravity Turbine Generator, Cyan 7, Anti-Gravity Turbine Generator,Magenta 8, Fire Hydrant Cap, Red 9,7 Segment Display, Green Q1) Giving the following tables (supplies, catalog, and part). For each part, show the query and demonstrate that it works correctly on the modified sample Parts/Suppliers/Catalog table insert into suppliers (sid, sname, address) values (6. 'OnlyGreen'. "GreenOnly"); insert into catalog (sid, pid, cost) values (6. 9. 20.0): The Parts lists the colors with capital letters: so, your queries involving green or red need to use Red or Green, respectively. Selected subparts: (5). (8). (10): SUPLLIES 1, Acme Widget Suppliers,"1 Grub St., Potemkin Village, IL 61801" 2,Big Red Tool and Die,"4 My Way, Bermuda Shorts, OR 90305" 3, Perfunctory Parts, "99999 Short Pier, Terra Del Fuego, TX 41299" 4, Alien Aircaft Inc., "2 Groom Lake, Rachel, NV 51902" Catalog 1, 3,0.50 1,4,0.50 1,8,11.70 2, 3,0.55 2,8,7.95 2,1,16.50 3, 8, 12.50 3,9,1.00 4,5,2.20 4,6,1247548.23 4,7,1247548.23 Parts 1, Left Handed Bacon Stretcher Cover, Red 2, Smoke Shifter End, Black 3, Acme Widget Washer, Red 4,Acme Widget Washer, Silver 5, I Brake for Crop Circles Sticker, Translucent 6, Anti-Gravity Turbine Generator, Cyan 7, Anti-Gravity Turbine Generator,Magenta 8, Fire Hydrant Cap, Red 9,7 Segment Display, Green