A database question. Here is the following database and question:

which facilities. Once bottled, this database also tracks the inventory available at each facility. Here are the tables (PKs are bold; FKs are underlined): Facility (FID, FName, FAddress, FCity, FState, Total Capacity Per Day) The facilities are the actual locations of the bottling activities. The Total Capacity of the Facility is maintained so that the managers may know how much product can be scheduled to be bottled at each individual facility. Line (FID, Line#, Location Information, Capacity Per Hour) Each facility may have more than one Line where a product may be bottled. The Line# is simply 1, 2, 3, etc., so the FID is needed to uniquely identify a line. The location within the facility is maintained (for example north line, etc.) as well as the bottling capacity of the line per hour. Product (PName, Flavor, Diet?, Caffeinated?) Products are the actual drinks the company offers. The Flavor might be Cola or Cherry; Diet? and Caffeinated? are Yes/No columns that indicate whether or not the product is a diet product or has caffeine. Schedule (PName, FID, Line#, Start Date, Start Time, End Time, Amount to Bottle) Once the manager decides on how much product to make (and where), he/she will make entries into this table. In Stock At Facility (FID, PName, Date Bottled, Amount In Stock) When the products are made, they are said to be in stock at the facility (the manager may then decide what to send out to retailers, based on this information). Thus, as a Schedule is completed, data would be added here to denote the increase in stock. Write the following queries in SQL: a) Determine the Line#, Location Information and Capacity per Hour for all lines scheduled to make "WIU Cola"(PName). b) Find the total stock of Caffeinated soda at all locations. Do this by adding up the Amount in Stock in all facilities in which the product in stock is Caffeinated