Given the following schema:
Catalog(sid, pid, price) (Line under sid and pid)
Suppliers(sid, sname, phonenum) (Line under sid)
Parts(pid, pname, color) (Line under pid)
Write the following queries in Relational Algebra: “Find names of suppliers who supply a blue part that costs less than 120 dollars and a yellow part that costs more than 150 dollars
Thank you. Please give an upvote. If any queries or changes needed please comment will respond ASAP!!!!!
Get Answers For Free
Most questions answered within 1 hours.