Answer Happy

a) Suppose you are the DBA of a company and created a relation called Employees with fields ename, dept, and salary. For authorization reasons, you also defined a view DeptInfo with fields dept and avg_salary, which lists the average salary of each department. Write a SQL statement to create the view DeptInfo. (3 marks)

b) Consider two relations R and S given below. Give the results of R INNER JOIN S, R LEFT OUTER JOIN S, and R RIGHT OUTER JOIN S. (3 marks) R S B B b с A X Y Z С 100 200 с e с