Question
Computer Science Question on Relational Algebra
Let us consider two relations Student and Major as shown in Table 1 and Table 2 respectively.
Table 1 : StudentSr No. | Name | Course |
---|---|---|
1. | Aman | CS |
2. | Ravi | ECO |
3. | Mohit | HIS |
4. | Sanjay | MATH |
Table 2 : MajorSr.No | Name | Course |
--- | --- | --- |
1. | Sanjay | MATH |
2. | Abhay | ENG |
3. | Sita | HINDI |
4. | Aman | CS |
5. | Ravi | ECO |
How many Tuples will be in the result table after Student U Major operation. |
A
9
B
8
C
20
D
6
Answer
6
Explanation
Solution
The correct option is (D) :6.