[Solved]Given Following Relational Schema Keys Underlined Employee Ename Salary Project Pname Agen Q37079899

Simple Query question

You are given the following relational schema (keys underlined): Employee (Ename, Salary) Project (Pname, Agency, Budget) Assign (Pname, Ename) Foreign keys: Ename in Assign references Employee (Ename). Pname i Project (Pname). Assign references Write the following queries in SQL: S: Find the emupo ad to maly one project S2: Find the employees whose salary is greater than Mark’s salary (Mark is an employee) S4: Find the projects with the budget lower than the average project budget at the same agency Which of the above queries has an equivalent relational algebra formulation Explain your answer For the queries that have an equivalent relational algebra formulation provide this formulation. Show transcribed image text You are given the following relational schema (keys underlined): Employee (Ename, Salary) Project (Pname, Agency, Budget) Assign (Pname, Ename) Foreign keys: Ename in Assign references Employee (Ename). Pname i Project (Pname). Assign references Write the following queries in SQL: S: Find the emupo ad to maly one project S2: Find the employees whose salary is greater than Mark’s salary (Mark is an employee) S4: Find the projects with the budget lower than the average project budget at the same agency Which of the above queries has an equivalent relational algebra formulation Explain your answer For the queries that have an equivalent relational algebra formulation provide this formulation.

Expert Answer

---

Answer to You are given the following relational schema (keys underlined): Employee (Ename, Salary) Project (Pname, Agency, Budget… . . .