1. Use the SQL Developer to login into your account
2. Now create the following tables : (xx is your login number)

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

also DOB, commission and GossSalary

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

Please note the code for rating as

1 = Full time employee

2 = Contract employee

3 = Visiting employee

3. Write the queries to:
   1. List all the Employees working in a branch in Kamloops
   2. List the average salary of managers in Kamloops
   3. List the difference in the salary than average salary of all the managers
   4. List all the details of all the employees with their branch details.
   5. List the non managers getting salary more than any of the manager
   6. List the non managers getting salary more than all the managers
   7. List the details of the manager of the oldest branch

4. Add two columns Manager (same as staffID) and managerSince (date) in branch table
5. Modify three tuples of the branch table to add manager code and managerSince date in branch table
6. Now run the queries:
   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.

This is a question of database system

Assignment due at 4p.m. today