Answered step by step
Verified Expert Solution
Link Copied!

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

image

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Digital Logic With Verilog Design

Authors: Stephen Brown, Zvonko Vranesic

3rd Edition

978-0073380544, 0073380547

More Books

Students also viewed these Programming questions