Question: QUESTION 01 Points[2.5+2.5+05] A) Convert the given query into relational algebraic expression also design query tree. SELECT 3.name, e. gubi FROM Students 3, Enrolments e
![QUESTION 01 Points[2.5+2.5+05] A) Convert the given query into relational algebraic](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f4dca717ee4_30266f4dca6af92f.jpg)
QUESTION 01 Points[2.5+2.5+05] A) Convert the given query into relational algebraic expression also design query tree. SELECT 3.name, e. gubi FROM Students 3, Enrolments e WHERE id = e.sid AND e.mark > 50; B) The following query returns information about all persons who have acted in a play that they have written: SELECT a.name...title.c:character name FROM Actor a Play Roler Where a.name=p.author AND a.actor_id=c.actor_id AND p.play_id=r:play.id Give a relational algebra query plan drawn as a tree that correctly computes this query. C) Explain following diagram SOL Parser RA Exp SQL DB Engine Relops Optimiser Output Tuples Display Results
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
