Use the Table to answer the following SQL question. Thanks

Table:

rider major

major_id Int (11) major_name varchar (25) major_description varchar (75) graduate_only char(1)

rider student

student_id Int (11) first_name varchar (25) last_name varchar (25) major_id Int (11) club_id Int (11)

1.Use the alter table statement to add a primary key constraint for the rider_student table.

2.Use the alter table statement to add a primary key for the rider_major table.

3.Use the alter table statement to change the rider_student and the rider_major table to use the InnoDB engine.

4.Use the alter table statement to create a table using the create table like syntax. Create a customers table in your database using the dbclass.customers table.

5.Use the insert into select from syntax to insert rows into the table you created in the previous step. You will insert rows from the dbclass.customers table into the table you created.

6.Use the alter table statement to create a check constraint on the customers table you created in the previous step. Create a constraint which guarantees that the values inserted into the age column are greater than 0.