Question: Can you show me how can i trace the answer using paper? Given the suppliers - parts - projects database, where the supplier supplies parts

Can you show me how can i trace the answer using paper?
Given the suppliers-parts -projects database, where the supplier supplies parts for projects, what is the resulting output table?
select snumber, sname
from supplier
where not EXISTS
(select *
from part
where not EXISTS
(select * from spj WHERE
spj.snumber = supplier.snumber AND spj.pnumber = part.pnumber ))
Can you show me how can i trace the answer using

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!