Question: Use both Tuple Relational Calculus (TRC) and Domain Relational Calculus (DRC) to express the following queries: SP Suppliers S# SNAME STATUS CITY S1 P1 300

Use both Tuple Relational Calculus (TRC) and Domain Relational Calculus (DRC) to express the following queries:

SP Suppliers S# SNAME STATUS CITY S1 P1 300 S P2 200 S1 P3400 S1P4 200 S1 P5100 S1P6 100 S2 P1 300 S2 P2400 S3P1 300 S3P2 200 S4 P2 200 S4 P3300 S4 P4 400 20 London S Smith S2 Jones S3 Blake Paris 30 Paris S4Clark 20 London S5Adams 30 Athens Parts P#PNAME COLOR WEIGHT CITY PINutRed 120 London 3 P1 300 P2 Bolt Green P3 Screw Blue P4 Screw Red 14.0 London 12.0 17.0Paris 17.0Oslo P5 Cam Blue 12.0 Paris P6 Cog Red 19.0 odon S4 PS 500 S4 P6 600
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
