relevant keys as suggested

Task 1: Create three tables with keys as in the above diagramTask 2: Insert record of 10 employees in the employee tableTask 3: Insert record of 5 departments in the department tableTask 4: Insert record of 5 salary levels in the salary tableTask 5: Write a query to display the information about the employees in the employeetableTask 6: Write a query to display the name of all the employeesTask 7: Write a query to display the name of all the employees and their jobname.Task 8: Write a query in SQL to display the unique jobname for all the employeesTask 9: Write a query to increase the salary for all the employees by 12%. Display theempname, jobname and salary after the incrementTask 10: Write a query to display the employee names with minimum and maximumsalary.Task 11: Write a query to display the employee id, employee name, jobname of all theemployees whose salary is greater than 90,000 P.A.

Assignment status: Already Solved By Our Experts

(USA, AUS, UK & CA  PhD. Writers)