relational algebra questions: Using the supplier-part database provided below, a

Question

relational algebra questions: 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.)

please show work to help me understand

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.

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

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

Explanation / Answer

1.

2.

3.

4.

5.

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

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