Consider the following relations: Employee (E-ID, Name, P-ID) Project ( P-ID, E-ID, P- Cost, P-Profit) Consider the following query on these relations: List the E-ID, Name, P-Code and P-Profit whose E-ID is 2017001 3. (a) Represent the above query using SQL (b) Convert the SQL query into equivalent relational algebraic query (c) Draw the query treefor the above relational algebraic query (d) Using the query tree, transform the relational algebraic query to an equivalent relational algebraic query which may reduce the query evaluation cost.
Answers
Answered by
1
Consider the following relations: Employee (E-ID, Name, P-ID) Project ( P-ID, E-ID, P- Cost, P-Profit) Consider the following query on these relations: List the E-ID, Name, P-Code and P-Profit whose E-ID is 2017001 3. (a) Represent the above query using SQL (b) Convert the SQL query into equivalent relational algebraic query (c) Draw the query treefor the above relational algebraic query (d) Using the query tree, transform the relational algebraic query to an equivalent relational algebraic query which may reduce the query evaluation cost.
Similar questions