A Suppose You Are The Dba Of A Company And Created A Relation Called Employees With Fields Ename Dept And Salary For 1 (34.21 KiB) Viewed 52 times
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 с
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!