Question: Write Relational Algebra Queries based on the following relationships: Table 2: Relationships Table Name Columns Book Sid (Primary key), Sname, Address Parts Pid (Primary key),
Write Relational Algebra Queries based on the following relationships:
Table 2: Relationships
| Table Name | Columns |
| Book | Sid (Primary key), Sname, Address |
| Parts | Pid (Primary key), Pname, Color |
| Catalog | Sid (Primary key), Pid (Primary key), Cost |
Q1) Write Relational Algebra query to Retrieve the supplier name for suppliers with any red part
Q2) Write Relational Algebra query to Retrieve the suppliers sids for suppliers with any red or green part
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
