Create an SQL program following the questions from 1 to 15

1. Write SQL code to set up table FW Lorry according to the following Relational Schema: FW Lorry(vehicleRegNo,make,model,maxLoad,accessories) imary key vehicleRegNo You must accommodate the following requirements: (a) For table and column names you must pick the names used in the (b) The vehicle registration number may contain letters and is al- (c) The make of the lorry is always one of the following: Volvo, schema above (otherwise you will lose marks as tests will fail) ways 7 characters long. Ashok, Ford, Hyundai, Iveco, MAN, Mercedes-Benz, Scania, Skoda, Tata. The company does not use any other. When or- dered, they should be ordered alphabetically on their string val- ues. Comparison, however, should be normal string comparison (like standard collation prescribes for strings) (d) The accessories can be any combination of the following four strings: Combination, Dual, EOBR, Tandem (which stand for combination truck, dual wheel usage on truck, electronic on- board recording system, and use of tandem axle on truck) 1. Write SQL code to set up table FW Lorry according to the following Relational Schema: FW Lorry(vehicleRegNo,make,model,maxLoad,accessories) imary key vehicleRegNo You must accommodate the following requirements: (a) For table and column names you must pick the names used in the (b) The vehicle registration number may contain letters and is al- (c) The make of the lorry is always one of the following: Volvo, schema above (otherwise you will lose marks as tests will fail) ways 7 characters long. Ashok, Ford, Hyundai, Iveco, MAN, Mercedes-Benz, Scania, Skoda, Tata. The company does not use any other. When or- dered, they should be ordered alphabetically on their string val- ues. Comparison, however, should be normal string comparison (like standard collation prescribes for strings) (d) The accessories can be any combination of the following four strings: Combination, Dual, EOBR, Tandem (which stand for combination truck, dual wheel usage on truck, electronic on- board recording system, and use of tandem axle on truck)