Please provide the answer in relational algebra with proper symbols. I have the

Question

Please provide the answer in relational algebra with proper symbols. I have the commands of these questions for RA interpreter but I want to solve it by hand using Relational Algebra.

Consider a database that consists of the following relations sname) of the PART(eno, Pname) PROJECT(Uno, Jname) SUPPLY(Sno, Pno, Ino) The database records information about suppliers, parts, and projects and includes a ternary relationship between suppliers, parts, and projects. This relationship is a many-many-many relationship. a. Retrieve the part numbers that are supplied to exactly two projects b. Retrieve the names of suppliers who supply more than two parts to proj- ect J1. c. Retrieve the part numbers that are supplied by every supplier. d. Retrieve the project names that are supplied by supplier si' only. e. Retrieve the names of suppliers who supply at least two different parts each to at least two different projects.

Explanation / Answer

Please find the required queries below :

a) select Pno from supply group by Pno,having count(Jno) > 2

b) select Sname from suppliers where Snp in (select s.Sno from supply s, project p where p.Jno=s.Jno and p.Jname = 'J1')

c) select distinct p.Pno, s.Sname from project p, supplier s oder by s.Sno

d) select p.Jname from project p, supplier s, supply u where p.Jno = u.Jno and s.Sno = u.Sno and s.Sname = 'S1'

e)

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.