Question: @ 28%O Problem 7.5 (**). Consider the following query on our Engineering database: SELECT ENAME, SAL FROM EMP, PROJ, ASG, PAY WHERE EMP.ENO - ASG.
@ 28%O Problem 7.5 (**). Consider the following query on our Engineering database: SELECT ENAME, SAL FROM EMP, PROJ, ASG, PAY WHERE EMP.ENO - ASG. ENO AND EMP.TITLE - PAY.TITLE AND (BUDGET>200000 OR DUR>24) AND ASG.PNO - PROJ.PNO AND (DUR>24 OR PNAME - "CAD/CAM") 10:21 PM Compose the selection predicate corresponding to the WHERE clause and transform it, using the idempotency rules, into the simplest equivalent form. Furthermore, compose an operator tree corresponding to the query and transform it, using relational algebra transformation rules, to three equivalent forms. ..ll Ooredoo
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
