1. Now use the following tables

staffxx (staffNo, lname, fname, dept, desig, joiningDate, salary, rating, branchCode, DOB, commission, GossSalary)

branchxx (branchCode, address, city, phone, yearOfOpening)

Where the code for rating is

1 = Full time employee

2 = Contract employee

3 = Visiting employee

Q2. You need to add two new columns as Manager (same as staffID) and managerSince (date) in branch table

Q3. Modify at least three tuples of the branch table to add manager code and managerSince date in branch table

Update branch set staffId=A1001 managerSince= ;

Q4. After updating, the queries needed are to: (6 x 2 + 3)

1. List the details of all the managers who are listed in branch table
2. List all the managers who are working as manager for more than 2 years
3. List a manager who is working as a manager at the same branch ever since he has joined.
4. Write the command to give 3% increment to all managers managing the branch that has been opened 10 years back.

Write commands, tables and screen shots