For the following queries:
Query A. List the department name, project name and the manager’sssn of the controlling
department of projects controlled by the Finance department andlocated in Dubai.
Query B. List the names of dependents of employees whose salaryis greater than 15000 Dirhams and work in the Researchdepartment.
Develop the following :
-
1) Write the SQL query.
-
2) TranslatetheSQLqueryintoRelationalAlgebraquery.
-
3) Create an initial (canonical) Query Tree.
-
4) MoveSELECToperationsdownthequerytree,ifapplicable.
-
5)ApplythemorerestrictiveSELECToperationsfirst,ifapplicable.
-
6)ReplaceCARTESIANPRODUCTandSELECTwithJOINoperations,ifapplicable.
-
7) MovePROJECToperationsdownthequerytree,ifapplicable.
Expert Answer
An answer will be send to you shortly. . . . .