Consider the following tables of a database: Instructor (InstructorID, InstructorName, JobStatus) Subject (SubCode, SubjectName, CreditHours) Taught (Subcode, InstructorID, Semester) Write SQL…

Consider the following tables of a database: Instructor (InstructorID, InstructorName, JobStatus) Subject (SubCode, SubjectName, CreditHours) Taught (Subcode, InstructorID, Semester) Write SQL Queries for the following: i) Insert a record with values "IT232", "DBMS", 3 in the Subject table ii) Change the JobStatus of an Instructor with ID 521 to 'Permanent' iii) To add a column "salary" in instructor table. iv) To display the name of instructor with highest salary. v) To delete a column credit hours from subject table.