- 2 Relational Algebra 120 Points For Following Questions You Should Formulate The Following Queries In Relational Alge 1 (30.47 KiB) Viewed 73 times
2. Relational Algebra 120 points) For following
questions, you should formulate the following queries in relational algebra according to relational schemas that are depicted below. Customer (custid: integer, name: string) Buys (custid: integer, itemno: integer, rating: char(2)) hem (temno: integer, description: string, seller: string) 15 Produce the custids and names of customers who buy the item with description "Memento movie" from seller "Hollywood Video". b.151 Produce itemno, rating of items and names of customers who buy the item with rating 'A'. Employee (empNo, IName, IName, address, DOB, sex, position, deptNo) Department (deptNo, deptName,mgrEmpNo) Project (projNo, projName, deptNo) WorksOn (empNo, projNo, date Worked, hours Worked) 151 Produ