Consider a database that consists of the following relations.

supplier(sno, sname)

part(pno, pname)

project(jno, jname)

supply(sno, pno, jno)

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. specify the

following queries in relational algebra.

1. retrieve the part numbers that are supplied to exactly two projects.

2. retrieve the names of suppliers who supply more than two parts to project j1.

3. retrieve the part numbers that are supplied by every supplier.

4. retrieve the project names that are supplied by supplier s1 only.

5. retrieve the names of suppliers who supply at least two dierent parts each to at least two dierent

projects.