Please provide the relation algebra, the oracle SQL code and the output tuples for the following (Answer #6 only the

Please find the below Query:

Select Concat(Fname,',',Minit,',',Lname) AS FullName from Employee e,Works_on w,project p where e.Ssn=w.Essn and w.Pno=p.Pnumber where p.Dnum=4;

As the works_on table and Project table has project number so we can join them.Also Works_on table has Essn which is same as Ssn in Employee table.so we can join them using that.

Output Tuples are below:

FullName

---------------

Franklin,T,Wong
Alicia,J,Zelaya
Ahmed,V,Jabbar
Jennifer,S,Wallace

I have not run the query in any compiler. So there may be some compilation error.

Please let me know if you have any doubt;