Question: Database Management Systems. Answer the questions using this table below using relational algebra. 1) Find the addresses of suppliers supplying Green parts. 2) Find the
Database Management Systems. Answer the questions using this table below using relational algebra.
1) Find the addresses of suppliers supplying Green parts.
2) Find the names of suppliers supplying parts of cost over 100.
3) Find the names of suppliers which supply a part named 'Acme Widget Washer'.
4) Find the name of suppliers that supply Red parts costing over 10. Once again , please use relational algebra. Not SQL
Suppliers(sid: integer sname: string, address: string) Parts(pid: iteger. pname: string, color: string)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
