Task 1: Create three tables with relevant keys as suggested 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)