Question: Queries (20 marks, Use Relational Algebra (ALG) to express the following queries based on the following suppliers-and- parts databases. Submit your algebra expressions for these
Queries (20 marks, 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 SP Suppliers SH SNAME STATUS CITY S1 Smith 20 London S2 Jones30 S3 Blake30 Paris S4 Clark 20 London S5 Adams 30 Athens S1 P1 300 S P2 200 S P3 400 S1 P4 S PS 100 S P6 100 Paris Parts PH PNAME COLOR WEIGHT CITYS2 P1 NutRed12.0 London S3 P2 200 S4 P2 200 S4 P3 300 SA P4 400 S4 PS 500 P6 600 Bolt Green 17.0 Paris P3 Screw Blue 170 Oslo Screw Red 140 London P5 CamBlue 12.0 Paris 9.0 London P6 Cog
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
