Question 1 Write a program that create a table named Salary as follows: create table Salary( firstName varchar(100), lastName varchar(100), rank varchar(15), salary float); Obtain the data for salary from the attached file and populate it into the Salary table in the database.
Question 2 Write a program that displays the content for salary table. And allow user to enter user name and update its salary.
Question 3 Write a program that update Salary which is lower than 65000 to be 70000 and display how many rows have been affected, by using .TYPE_SCROLL_SENSITIVE. Submit each program alone with a screen shots of database after and before execution.