Solveeit Logo

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.NameCourse
1.AmanCS
2.RaviECO
3.MohitHIS
4.SanjayMATH
Table 2 : MajorSr.NoNameCourse
---------
1.SanjayMATH
2.AbhayENG
3.SitaHINDI
4.AmanCS
5.RaviECO
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.