Question:
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.
Let us consider two relations Student and Major as shown in Table 1 and Table 2 respectively.
Table 1 : Student
Table 2 : Major
How many Tuples will be in the result table after Student U Major operation.
Table 1 : Student
| Sr No. | Name | Course |
| 1. | Aman | CS |
| 2. | Ravi | ECO |
| 3. | Mohit | HIS |
| 4. | Sanjay | MATH |
| Sr.No | Name | Course |
| 1. | Sanjay | MATH |
| 2. | Abhay | ENG |
| 3. | Sita | HINDI |
| 4. | Aman | CS |
| 5. | Ravi | ECO |
Updated On: Sep 23, 2024
- 9
- 8
- 20
- 6
Hide Solution
Verified By Collegedunia
The Correct Option is D
Solution and Explanation
The correct option is (D) :6.
Was this answer helpful?
0
0
Top Questions on Relational Algebra
Consider the following tables, Loan and Borrower, of a bank.
Query: \[ \pi_{\text{branch\_name}, \text{customer\_name}} (\text{Loan} \bowtie \text{Borrower}) \div \pi_{\text{branch\_name}}(\text{Loan}) \] where \( \bowtie \) denotes natural join. The number of tuples returned by the above relational algebra query is 1 (Answer in integer).- GATE DA - 2025
- Computer Science
- Relational Algebra
- Consider the following three relations:
Car (model, year, serial, color)
Make (maker, model)
Own (owner, serial)
A tuple in Car represents a specific car of a given model, made in a given year, with a serial number and a color. A tuple in Make specifies that a maker company makes cars of a certain model. A tuple in Own specifies that an owner owns the car with a given serial number. Keys are underlined; (owner, serial) together form key for Own. (\(\bowtie\) denotes natural join)
\[ \pi_{owner} \left( Own \bowtie \sigma_{color="red"} \left( Car \bowtie \sigma_{maker="ABC"} Make \right) \right) \] Which one of the following options describes what the above expression computes?- GATE DA - 2025
- Computer Science
- Relational Algebra
Questions Asked in CUET exam
- Two slits are made 0.1 mm apart and the screen is placed 2 m away. The fringe separation when a light of wavelength 500 nm is used is______.
Fill in the blank with the correct answer from the options given below. - Lower half of a convex lens is made opaque. Which of the following describes the image of the object placed in front of the lens?(A) No change in image
(B) Image will show only half of the object
(C) Intensity of image gets reduced
Choose the correct answer from the options given below. - Complete the sentences given in List-I with the appropriate prepositions given in List-II:
- If $f(x) = x^2 + bx + 1$ is increasing in the interval $[1, 2]$, then the least value of $b$ is:
- CUET (UG) - 2024
- Increasing and Decreasing Functions
- What will be the increasing order of basic strength of the following compounds: \(\text{C}_2\text{H}_5\text{NH}_2, (\text{C}_2\text{H}_5)_2\text{NH},(\text{C}_2\text{H}_5)_3\text{N},\text{C}_6\text{H}_5\text{NH}_2\)
View More Questions