This is a database question. Here is the Database for the following 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. The Schedule entries have an "Amount to Bottle" column but this may not be within the capacity of the line. Write a DML command in SQL that will change any Amount to Bottle column value that is greater than the capacity of the line, to be the capacity of the line