Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SQL queries on following Tables SUPPLIERS,PARTS, SUPPLIER_PART Please Help me out in these queries. 1) Get supplier names for suppliers who supply the parts. Blue

SQL queries on following Tables SUPPLIERS,PARTS, SUPPLIER_PART

image text in transcribed

Please Help me out in these queries.

1) Get supplier names for suppliers who supply the parts. Blue Parts.

2) Get all pairs of supplier numbers who reside in the same city.

3) Get supplier names for suppliers who do not supply part p2.

4) Get supplier names for suppliers who supply all parts.

s (Supplier) SNAME Smith S2 Jones S3 Blake S4 Clark S5 Adams P Part PNAME PI Nut Bolt P2 P3 Screw P4 Screw P5 Cam P6 Cog SP 300 P2 200 400 P4, 200 PS 100 100 S2 Pu 300 P2 400 P2 200 P2 200 S4 P4 300 400 STATUS 20 30 20 30 COLOR Red Green Blue Red Blue Red CITY London Paris Paris London Athens WEIGHT CITY 12.0 17.00 17.0 14.0 12.0 19.00 London Paris Rome London Paris London

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Practical Database Programming With Visual C# .NET

Authors: Ying Bai

1st Edition

0470467274, 978-0470467275

More Books

Students also viewed these Databases questions

Question

3. Are there distributed processing functions?

Answered: 1 week ago

Question

Define the term Working Capital Gap.

Answered: 1 week ago

Question

3. Is IBMs program really a mentoring program? Why or why not?

Answered: 1 week ago