Q42Section DA (Data Science and Artificial Intelligence (Q11–Q65))42 of 65
Evaluating a filtered join-based relational algebra expression
Consider the given relations , and . The relation has three columns , and . The relation has three columns , and . The relation has two columns and .
| | | | |—|—|—| | P1 | Q1 | R1 | | P2 | Q2 | R2 | | P3 | Q3 | R2 |
| | | | |—|—|—| | P1 | Q1 | 2 | | P1 | Q2 | 5 | | P2 | Q1 | 6 | | P3 | Q3 | 1 |
| | | |—|—| | P1 | T1 | | P3 | T2 | | P4 | T3 | | P4 | NULL |
Consider the relational algebra expression where denotes natural join operation. Which of the following options is the correct output for the given expression?
Pick an option to check your answer. In a mock test a wrong answer here costs 2/3 mark.