Please note:the PK for Employee Table is SSN, PK for Department Table is Dnumber, PK for Dependent Table is Essn

Use the table below to transfer the SQL into relational algebra and then draw the most efficient query graph you can using the relational algebra phrases. Use the heuristic rules of pushing Selects down, recoding joins, and pushing Projects down in your graph FK: Employee. dno Department.dnumber Employee Table Lname Smith Jones Fname John Ali SSN 12345 67890 Salary 41000 42000 Address 123 1st str, TX5 456 2nd str, TX 5 dno Department Table Dname Research Admission HR Dnumber 5 4 FK: Dependent.essn Employee.ssn Dependent Table Essn 12345 12345 12345 Dep _name Michael Smith Alice Smith Lili Smith