DATABASE.docx - 1. Create the table employee with the...

1. Create the table employee with the following structure.
2. Write a query to display the employee number, first name and salary increased by 15%. Label the column New
Salary.

3.Modify the above query to add a column that will subtract the old salary from the new salary. Label the column
Increase.
3.Execute the following statement to create the table department.
CREATE table department(
deptno VARCHAR(3)NOT NULL PRIMARY KEY,
deptname VARCHAR(30),
mgrnoVARCHAR(6),
location VARCHAR(10))

4.Insert records into the departmenttable as shown in the tabular format.