2. Relational Algebra 120 points) For following questions, you should formulate the following queries in relational alge
-
- Posts: 43759
- Joined: Sat Aug 07, 2021 7:38 am
2. Relational Algebra 120 points) For following questions, you should formulate the following queries in relational alge
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
2. Relational Algebra 120 points) For following