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.
