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 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
Get step-by-step solutions from verified subject matter experts
