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

1.   Show the result of a project operation that lists the SNO, SNAME, and STATUS attributes of all suppliers (S table).

2.   Show the result of a restrict operation that lists the suppliers (S table) in Paris and Athens.

3.   Show the result of project and restriction operations that list the SNO, SNAME, and STATUS attributes of the suppliers (S table) in London and Athens.

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

Find the answers below.

1. SELECT SNO, SNAME, STATUS FROM SUPPLIERS;

2. SELECT * FROM SUPPLIERS WHERE CITY IN ('Paris', 'Athens');

3. SELECT SNO, SNAME, STATUS FROM SUPPLIERS WHERE CITY IN ('London', 'Athens');

output:

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

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