a$.$ Write the SQL code to create a view, EmployeeGrades, in which we can store the EmployeeID and Grade of each employee. Compute the grade as described above.

$[5$ Marks$]$

b$.$ For each of the queries below, answer in Relational Algebra as well as SQL form:

i$.$ Show the EmploveeName, Salary and DepartmentName for all the managers.

ii$.$ Show the EmployeeName and Grade for all employees working at$"$Location$=$'NewYork'.

iii. Show for the EmploveeName$=$'Smith' the maximum possible raise in Salary in the same Grade.

c$.$ For each of the queries below, answer in SQL forntonly.

$]=[10$ Marks

i$.$ Show the sum of Salary of employees in a department and the DepartmentName for each department. Assume DepartmentName is also unique field.

ii$.$ Show the EmployeeName for all the employees in the salary Grade$=\text{'}$G$1\text{'}.$ You must use a nested query for this.

Note: The fields that must appear in the output are typed in Italic.