Please use the data(Plano, Coppell etc) in the picture. Please put the results only and please acutally do the questions

[answerhappygod]

Please use the data(Plano, Coppell etc) in the picture.
Please put the results only and please acutally do the questions
and not copy paste from the other answers
Thank you
1. Show the result of a project operation that lists the SNAME
and CITY attributes of all suppliers.
2. Show the result of a restrict operation that lists suppliers
in COPPELL and TEMPLE.
3. Show the result of a project & restrict operation that
lists the SNAME and CITY attributes of suppliers in COPPELL and
TEMPLE. 4. Show the result of the natural join that combines the
suppliers (S table) and parts (P table).
5. 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.
6. 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.
7. Show the result of the full outer join between the P (part)
and S (supplier) tables using the common CITY column.
8. Show PNO, PNAME, and CITY of parts that supplier ‘S2’ did not
supply,
9. Show PNO, PNAME, and CITY of parts that were supplied to all
projects in J table. (See textbook §3.4.7 for divide operator.)
10. Show the result of an aggregate operation on the SPJ table.
The grouping column is PNO and the aggregate calculation is the sum
of QTY values.

Please Use The Data Plano Coppell Etc In The Picture Please Put The Results Only And Please Acutally Do The Questions 1 (152.65 KiB) Viewed 25 times

Supplier-Part-Project Database S Table (for Suppliers) SNO SNAME STATUS CITY s1 Smith 20 Coppell S2 Moore 10 Plano S3 Brown 30 Plano S4 Miller 20 Coppell S5 Davis 30 Temple P Table (for Parts) PNO | PNAME COLOR WEIGHT CITY P1 Nut Red Coppell 12 17 Plano P2 Bolt Green P3 Screw Blue 17 Murphy P4 Screw Red 14 Coppell P5 Cam Blue 12 Plano P6 Cog Red 19 Coppell JTable (for Projects) JNO JNAME CITY J1 Sorter Plano J2 Display Waco J3 OCR J4 Console J5 RAID J6 EDS J7 Tape Temple Temple Coppell Murphy Coppell SPJ Table SNO PNO JNO QTY S1 P1 J1 200 s1 P1 J4 300 S2 P3 J1 400 S2 P3 J2 200 200 S2 P3 J3 S2 P3 J4 500 P3 J5 600 S2 S2 S2 P3 J6 400 P3 J7 800 S2 P5 J2 100 S3 P3 J1 500 J3 500 J3 300 P6 J7 300 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). es es es eses esses esses es eses es eses is esses N N N N N N N N M MAIS 1 10 10 10 10 S3 S4 S5 tytt w w w w w ty to P4 S4 P6 es 5 PP FOTO 34 to toto to to to t сл сл сл NM