Exercise 20.6 consider the following bcnf relations, which describe employees and the departments they work in: emp (eid, sal, did) dept (did, location, budget)you are told that the following queries are extremely important: i find the location where a user-specified employee works. i check whether the budget of a department is greater than the salary of each employee in that department.1. describe the physical design you would choose for this relation. that is, what kind of a file structure would you choosefor these relations, and what indexes would you create? 2. suppose that your customers subsequently complain that performance is still not satisfactory (given the indexes and fileorganization that you chose for the relations in response to the previous question). since you cannot afford to buy newhardware or software, you have to consider a schema redesign. explain how you would try to obtain better performanceby describing the schema for the relation(s) that you would use and your choice of file organizations and indexes on theserelations.3. suppose that your database system has very inefficient implementations of index structures. what kind of a designwould you try in this case?