Using the supplier-part database provided below, answer each of the following re

Question

Using the supplier-part database provided below, answer each of the following relational algebra questions. (Note: Does not require the use of SQL or any database software. The results must be manually generated.)

7.   Show the result of a full outer join between the S (supplier) and P (part) tables using the common CITY column.

8.   Show the result of a summarize operation on P table. The grouping column is CITY and the aggregate calculation is COUNT.

9.   Show the result of a summarize operation on SP. The grouping column is CITY and the aggregate calculations are the minimum and maximum STATUS values.

https://www.chegg.com/homework-help/questions-and-answers/using-supplier-part-database-provided-answer-following-relational-algebra-questions-note-r-q22282331

https://www.chegg.com/homework-help/questions-and-answers/using-supplier-part-database-provided-answer-following-relational-algebra-questions-note-r-q22282351

https://www.chegg.com/homework-help/questions-and-answers/using-supplier-part-database-provided-answer-following-relational-algebra-questions-note-r-q22282397

Explanation / Answer

7

8

COUNT(CITY) = 3

9

MIN(STATUS) = 10

MAX(STATUS) = 30

SNO SNAME STATUS CITY PNO PNAME COLOR WEIGHT CITY S1 Smith 20 London P1 Nut Red 12 London S1 Smith 20 London P4 Screw Red 14 London S1 Smith 20 London P6 Cog Red 19 London S4 Clark 20 London P1 Nut Red 12 London S4 Clark 20 London P4 Screw Red 14 London S4 Clark 20 London P6 Cog Red 19 London S2 Jones 10 Paris P2 Bolt Green 17 Paris S2 Jones 10 Paris P5 Cam Blue 12 Paris S3 Blake 30 Paris P2 Bolt Green 17 Paris S3 Blake 30 Paris P5 Cam Blue 12 Paris S5 Adams 30 Athens P3 Screw Blue 17 Rome

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.