Answered step by step
Verified Expert Solution
Question
1 Approved Answer
S Table (for Suppliers) ======================== SNO SNAME STATUS CITY ======================== S1 Smith 20 Cypress S2 Moore 10 Humble S3 Brown 30 Humble S4 Miller 20
S Table (for Suppliers) ======================== SNO SNAME STATUS CITY ======================== S1 Smith 20 Cypress S2 Moore 10 Humble S3 Brown 30 Humble S4 Miller 20 Cypress S5 Peters 30 Alvin ======================== P Table (for Parts) =============================== PNO PNAME COLOR WEIGHT CITY =============================== P1 Nut Red 12 Cypress P2 Bolt Green 17 Humble P3 Screw Blue 17 Pearland P4 Screw Red 14 Cypress P5 Cam Blue 12 Humble P6 Cog Red 19 Cypress =============================== J Table (for Projects) ==================== JNO JNAME CITY ==================== J1 Sorter Humble J2 Display Katy J3 OCR Alvin J4 Console Alvin J5 RAID Cypress J6 EDS Pearland J7 Tape Cypress ==================== SPJ Table =============== SNO PNO JNO QTY =============== S1 P1 J1 200 S1 P1 J4 300 S2 P3 J1 400 S2 P3 J2 200 S2 P3 J3 200 S2 P3 J4 500 S2 P3 J5 600 S2 P3 J6 400 S2 P3 J7 800 S2 P5 J2 100 S3 P3 J1 500 S3 P4 J3 500 S4 P6 J3 300 S4 P6 J7 300 S5 P1 J2 200 S5 P2 J4 100 S5 P3 J4 200 S5 P4 J4 700 S5 P5 J4 400 S5 P5 J5 500 S5 P5 J7 700 S5 P6 J2 200 S5 P6 J4 500 =============== (NOTE: QTY stands for quantity.) SPJ table shows which supplier (SNO) supplied how many units (QTY) of what part (PNO) for which project (JNO).
1. Show the result of a one-sided outer join between the P (part) and S (supplier) tables using the common CITY column. Preserve the rows of the S table in the result.
2. Show the result of a one-sided outer join between the P (part) and S (supplier) tables using the common CITY column. Preserve the rows of the P table in the result.
3. Show the result of the full outer join between the P (part) and S (supplier) tables using the common CITY column.
4. Show SNO, SNAME, and STATUS of suppliers who supplied all parts of the P table.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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