Provide relational algebra (NOT SQL) queries to find the following information SUPPLIER (SNo, SupplierName, City) PART (PNo, PartName, Weight) PROJECT (JobNo, JobName, StartYear, Country) SUPPLY ( SNo...


Provide
relational algebra
(NOT SQL) queries to find the following information


SUPPLIER (SNo, SupplierName, City)


PART (PNo, PartName, Weight)


PROJECT (JobNo, JobName, StartYear, Country)


SUPPLY (SNo,
PNo,
JobNo, Quantity)



  1. List the names of Suppliers who have supplied the Part with the name “Fufful Valve”.

  2. List the names of Projects that have had Parts supplied by “Insightly Co#” or a Supplier located in Dubai.

  3. List the details of any supplier who has supplied parts to a project that stared in 2020 and (the project is) located in Singapore.

  4. List the name of any part that was not used on a project that commenced in 2020.




Jun 05, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here