Sheet10QueryOptimization
.docx
School
Cairo University**We aren't endorsed by this school
Course
CMP 202
Subject
Information Systems
Date
Dec 30, 2024
Pages
1
Uploaded by SuperFire15771
Database Management SystemsCMPS202/CMP2020Sheet 10: Query Optimization1.Given the Company database schema below, write the following queries in SQL then, for each query, drawthe initial query tree and then show how the query tree is optimized using heuristicsa.Get department names for departments that have a female manager and have at least one location in Aswan.b.Get names of Employees whose salary > 30000 and works on a project located in Cairoc.Get project names and employees names for employees working more than 30 hours in a project in Tanta and is controlled by a department ‘research’ 1/1
