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 andincludes a ternary relationship between suppliers, parts, and projects. Thisrelationship is a many-many-many relationships. Specify and execute the followingqueries using the relational algebra Retrieve the part numbers that are supplied to exactly two projects. b. Retrieve the names of suppliers who supply more than two parts to project J11 c. Retrieve the part numbers that are supplied by every supplier. d. Retrieve the project names that are supplied by supplier S1' only. e. Retrieve the names of suppliers who supply at least two different parts each to at least two different projects.
Consider a
SUPpLIER(Sno. Sname)
PART(Pno, Pname)
PROJECT(Jno, Jname)
SUPPLY(Sno, Pno, Jno)
The database records information about suppliers, parts, and projects
andincludes a ternary relationship between suppliers, parts, and projects.
Thisrelationship is a many-many-many relationships. Specify and execute the
followingqueries using the relational algebra
Retrieve the part numbers that are supplied to exactly two projects.
b. Retrieve the names of suppliers who supply more than two parts to
project J11
c. Retrieve the part numbers that are supplied by every supplier.
d. Retrieve the project names that are supplied by supplier S1' only.
e. Retrieve the names of suppliers who supply at least two different parts
each to at least two different projects.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
