SQL Tasks

Use the data definition language component of SQL to:

1. Write the CREATE table statements to implement the tables as defined above.
2. Write INSERT statements to insert data into the tables as shown above.
3. ALTER the checkconstraint in the tblLesson table so that possiblevalues for less_airport column are: "Pullman", "Colfax", and "Palouse".

( e J TABLE 1: tblinstructor H+ tblInstructor inst_ID inst_firstName inst firstName inst lastName 1 Tom 2 Susan 3 Mike 4 Kate Datatypes for tblinstructor Column Name < inst ID inst_lastName Smith White Watson Ross Description The unique identifier for the instructor table. < PRIMARY KEY The instructor's first name. < The instructor's last name. < Data Type int Varchar, 150 characters. Required. < Varchar, 150 characters. Required.