Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 1 1 . Get all pairs of city names such that a supplier in the first city supplies a job in the second city

QUESTION 11. Get all pairs of city names such that a supplier in the first city supplies a job in the second city
Suppliers-Parts-Jobs (SPJ) Database Practice Queries
Consider the following relational database about suppliers, parts, and jobs.
P(P#, PName, Color, City )
J(J#, JName, City )
SPJ(S#,P#, #,QTY)
Suppliers (S), parts (P), and jobs (J) are uniquely identified by supplier number (S#), part number (P#), and
job number (J#), respectively. The significance of an SPJ (shipment) record is that the specified supplier
supplies the specified part to the specified job in the specified quantity (and the combination S#, P#, J#
uniquely identifies such a record). An instance of this database is given below.
image text in transcribed

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

More Books

Students also viewed these Databases questions