Assignment title: Information
1. Create a text file named Create_.sql (for example, Create_3087654.sql) that will contain SQL statements to: I. Create a database named CTSDB II. Create all of the tables for the database according to the Database schema given at the end of this document 2. Create a text file named Insert_.sql that will contain SQL statements to: I. Insert at least five records in each of the tables. The test data inserted into the table must ensure that each of the queries, specified in Task 3, outputs at least one record 3. Create a text file named Query_.sql that will contain all the queries to display the following I. A list of available Vehicles sorted according to seating capacity. Display the Model, Registration number, and the Seating capacity. II. A list of Official sorted according to their First name followed by Last name. Display their country name as well as the languages they speak. III. List the drivers who speak French. Display their First name and Last name.