Given the following database of a Bus company. The underlined attributes represent the primary key The bus capacity represents the maximum number of passengers of the bus. The Schedule table contains the scheduling of buses and drivers on the several routes. Add the color field to the Bus table. Add the following constraint to the Bus table: "Possible values of Bus type are: A, B, C D, F and E". For all buses of the type 'A', assign the color 'blue'. Give the total bus capacity the number of drivers. For each city, calculate the number of drivers. Give the numbers and names of the drivers who are scheduled today on a bus with a capacity of more than 50 Give the numbers and names of the drivers who have not been scheduled to a bus of type 'A'. Give the numbers and names of the drivers who drive one of buses which was driving by the driver "Smith". Give the bus (or buses) number that has the second highest capacity Give the numbers and names of the drivers who drive only, buses of type 'A' Give the numbers and names of the drivers who arc scheduled two times, at least, on the same bus Give the numbers and names of the drivers who are travelling on all routes with more than 10 stops. Remove all drivers that have not been scheduled and remove all buses that have not been not scheduled after 1/1/2005