uestion 3 Consider the following BCNF relations, which describe departments in a company and mployees: Dept(did, dname, location, managerid) You are told that the following queries are extremely important and frequently used: Emp(eid, sal) List the names and ids of managers for each department in a user-specified location, and in alphabetical order by department name. Find the average salary of employees who manage departments in a user-specified location. You can assume that no one manages more than one department. Describe the file structures and indexes that you would choose for improving the execution time of these transactions