Question Question Based on the relational schema below: class=”ql-cursor”> Emp(eid: integer, ename: string, age: integer, salary: real) Works(eid: integer, did: integer, pcttime: integer) Dept(did: integer, dname: string, budget: real, managerid: integer) Express the following queries in Relational Algebra. 1.Find the names and salary of each employee who works in both the Sales Department and the Engineering department (assume that Sales Dept ID =101 and Engineering Dept ID = 201). : class=”ql-cursor”> Emp(eid: integer, ename: string, age: integer, salary: real) Works(eid: integer, did: integer, pcttime: integer) Dept(did: integer, dname: string, budget: real, managerid: integer) Express the following queries in Relational Algebra. 1.Find the names and salary of each employee who works in both the Sales Department and the Engineering department (assume that Sales Dept ID =101 and Engineering Dept ID = 201).
Question
Based on the relational schema below: class=”ql-cursor”> Emp(eid: integer, ename: string, age: integer, salary: real) Works(eid: integer, did: integer, pcttime: integer) Dept(did: integer, dname: string, budget: real, managerid: integer)
Express the following queries in Relational Algebra.
1.Find the names and salary of each employee who works in both the Sales Department and the Engineering department (assume that Sales Dept ID =101 and Engineering Dept ID = 201).
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
