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

 Use Relational Algebra (ALG) to express the following queries based onthe following suppliers-and- parts databases. Submit your algcbra expressions for these queries

Use Relational Algebra (ALG) to express the following queries based on the following suppliers-and- parts databases. Submit your algcbra expressions for these queries as well as the query results. SA SNAME STATUS CITY SI Smith S2 Jones 30 S3 Blake30 Paris S4 Clark S5 Adams 30 Paris SI P3 400 100 100 Athens Parts PA PNAME COLOR WEIGHT CITY PI Nut Red 120 53 Paris Oslo P2 Bol 17.0 P3 Screw Blue 7.0 14.0 12.0 19.0 S4 54 S4. P4 SereW Red P5 Cam Blu Red I. 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 cither blue or green parts. 6. Get supplier namepart name pairs such that the indicated supplier does not supply the indicated part 7. 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 Pl. 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!