Question: Use Relational Algebra (ALG) to express the following queries based on the following suppliers-and parts databases. Submit your algebra expressions for these queries as well

 Use Relational Algebra (ALG) to express the following queries based on

Use Relational Algebra (ALG) to express the following queries based on the following suppliers-and parts databases. Submit your algebra expressions for these queries as well as the query results. 200 200 Suppliers SP S# SNAME STATUS CITY SH P# QTY S1 Smith 20 S1 PI 300 London s2 Jones 30 s1 P2 200 Paris S1 P3 400 S3 Blake 30 Paris s1 P4 200 S4 Clark 20 London Athens S1 P5 S5 Adams 30 100 S1 P6 100 Parts S2 P1 300 P# PNAME COLOR WEIGHT CITY s2 P 400 P1 Nut Red 120 London S3 P2 P2 Bolt Green 170 Paris S4 P2 P3 Screw Blue 170 Oslo S4 P3 300 P4 Screw Red 14.0 London s4 P4 400 Ps Cam Blue 120 Paris s4 Ps 500 P6 Cog Red 190 London s4 P6 600 1. Get the part names that Adams provides. 2. Get supplier names for suppliers who supply part P2. 3. Get supplier names and the quantity of parts supplied. 4. Get supplier names for suppliers who supply parts with quantity less than 300 5. Get supplier names for suppliers who supply either blue or green parts. 6. Get supplier name/part name pairs such that the indicated supplier does not supply the indicated part. Get supplier names for suppliers who does not supply any parts. 8. Get supplier names for suppliers who supply all parts. 9. Get supplier names for suppliers who supply all parts except P1 10. Get supplier names and the number of parts and total quantity supplied

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!