Specify the following views in SQL on company database schema in Fig 5.5

a)A view that has the department name,manager name and manager salary for every department.

b)A view that has the employee name,supervisor name and employee salary for each employee who works in the research department.