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.)

4.   Show the result of a natural join that combines the suppliers (S table) and supplier-part data (SP table).

5.   Show the result of a natural join and restriction operations that combine the suppliers (S table) in Paris and supplier-part data (SP table).

6.   Show the result of a one-sided outer join between the S (supplier) and SP (supplier-part) tables. Preserve the rows of the S table in the result.

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-q22282371

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

Explanation / Answer

4.

5.

6.

SNO SNAME STATUS CITY SNO PNO QTY S1 Smith 20 London S1 P1 300 S1 Smith 20 London S1 P2 200 S1 Smith 20 London S1 P3 400 S1 Smith 20 London S1 P4 200 S1 Smith 20 London S1 P5 100 S1 Smith 20 London S1 P6 100 S2 Jones 10 Paris S2 P1 300 S2 Jones 10 Paris S2 P2 400 S3 Blake 30 Paris S3 P2 200 S4 Clark 20 London S4 P2 200 S4 Clark 20 London S4 P4 300 S4 Clark 20 London S4 P5 400

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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