Homework Sourse1 compute R1R2R3 2 compute R1 full outer joinR1BR3B R3 R1 R2
1) compute R1*R2*R3
2) compute R1 full outer join(R1.B=R3.B) R3
R1
R2
R3
| A | B |
| 1 | a |
| 2 | c |
| 3 | a |
| 4 | a |
| 5 | b |
Solution
For 1, there will be a total of 60 rows, as, there are 5 rows, in R1, 4 rows in R2, and 3 rows in R3, the total number of rows in R1 x R2 x R3 = 5 x 4 x 3 = 60.
R1 full outer join(R1.B=R3.B) R3:
| R1.A | R1.B | R2.A | R2.C | R3.B | R3.D |
| 1 | a | 4 | e | a | g |
| 1 | a | 4 | e | b | h |
| 1 | a | 4 | e | d | h |
| 1 | a | 1 | f | a | g |
| 1 | a | 1 | f | b | h |
| 1 | a | 1 | f | d | h |
| 1 | a | 1 | g | a | g |
| 1 | a | 1 | g | b | h |
| 1 | a | 1 | g | d | h |
| 1 | a | 2 | e | a | g |
| 1 | a | 2 | e | b | h |
| 1 | a | 2 | e | d | h |
| 2 | c | 4 | e | a | g |
| 2 | c | 4 | e | b | h |
| 2 | c | 4 | e | d | h |
| 2 | c | 1 | f | a | g |
| 2 | c | 1 | f | b | h |
| 2 | c | 1 | f | d | h |
| 2 | c | 1 | g | a | g |
| 2 | c | 1 | g | b | h |
| 2 | c | 1 | g | d | h |
| 2 | c | 2 | e | a | g |
| 2 | c | 2 | e | b | h |
| 2 | c | 2 | e | d | h |
| 3 | a | 4 | e | a | g |
| 3 | a | 4 | e | b | h |
| 3 | a | 4 | e | d | h |
| 3 | a | 1 | f | a | g |
| 3 | a | 1 | f | b | h |
| 3 | a | 1 | f | d | h |
| 3 | a | 1 | g | a | g |
| 3 | a | 1 | g | b | h |
| 3 | a | 1 | g | d | h |
| 3 | a | 2 | e | a | g |
| 3 | a | 2 | e | b | h |
| 3 | a | 2 | e | d | h |
| 4 | a | 4 | e | a | g |
| 4 | a | 4 | e | b | h |
| 4 | a | 4 | e | d | h |
| 4 | a | 1 | f | a | g |
| 4 | a | 1 | f | b | h |
| 4 | a | 1 | f | d | h |
| 4 | a | 1 | g | a | g |
| 4 | a | 1 | g | b | h |
| 4 | a | 1 | g | d | h |
| 4 | a | 2 | e | a | g |
| 4 | a | 2 | e | b | h |
| 4 | a | 2 | e | d | h |
| 5 | b | 4 | e | a | g |
| 5 | b | 4 | e | b | h |
| 5 | b | 4 | e | d | h |
| 5 | b | 1 | f | a | g |
| 5 | b | 1 | f | b | h |
| 5 | b | 1 | f | d | h |
| 5 | b | 1 | g | a | g |
| 5 | b | 1 | g | b | h |
| 5 | b | 1 | g | d | h |
| 5 | b | 2 | e | a | g |
| 5 | b | 2 | e | b | h |
| 5 | b | 2 | e | d | h |
