Date: COMP122 Final Term test Question 2 CREATE a table called FINALSTUDENT with the following fields student no-> primary key with constraint name stu_name Coursename-create constraint which accept only 'TT' 'Mechanical', Management', Electrical Campus Create a composite primary key in the student table 1. 2. 3. Insert 3 records Write a sql command to Add two columns to student table which is Phone no and Date of joining (default value should be the system date) to the existing table Insert the phone number for all the 3 records 5. 4. Mark the phone no column as unused.verify that the column is no longer available 6. Delete the phone no column in the student table 7. Create a self join query 8. Display all the constraints in FINALSTUDENT table 9. Create a query using the SET operators 10. Create a query using %, like operator