Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The database contains three tables: Suppliers_T(Key: SNUM), Parts_T(Key: PNUM) and Shipment T(Key: SNUM, PNUM). Assume all the tables are connected through foreign keys. SNUM
The database contains three tables: Suppliers_T(Key: SNUM), Parts_T(Key: PNUM) and Shipment T(Key: SNUM, PNUM). Assume all the tables are connected through foreign keys. SNUM S1 S2 S3 S4 S5 PNUM P1 P2 P3 P4 P5 P6 Suppliers T SNAME STATUS CITY Smith 20 London Jones 10 Paris Blake 30 Paris 20 London. 30 Athens Clark Adams Parts T PNAME COLOR WEIGHT Nut Red 12 Bolt Green 17 Blue 17 Red 14 Cam Blue 15 Cog Red 19 Screw Screw SELECT DISTINCT Shipment_T.PNUM FROM Suppliers_T, Shipment T WHERE Suppliers_T.SNUM = Shipment_T.SNUM AND Suppliers T.SNAME = 'Jones'; A) 0 B) 2 24. What is the record returned by the following query? SELECT MIN(Parts_T.WEIGHT) FROM Parts T SNUM S1 $1 $1 S2 GROUP BY COLOR HAVING MIN(Parts_T.WEIGHT)
Step by Step Solution
★★★★★
3.34 Rating (163 Votes )
There are 3 Steps involved in it
Step: 1
23 B Suppliers TSNUM ShipmentTSNUM returns all the records fr...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started