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
- Let us consider two relations HISTORY and SCIENCE as depicted in the following Tables 1 and 2 respectively:
Table 1: HISTORYSNo NAME CLASS 1 MOHAN 6A 2 SANJAY 6B 3 YOGESH 7A
Table 2: SCIENCESNo NAME CLASS 1 NARESH 6B 2 SANJAY 6B 3 YOGESH 7A
What is the output of HISTORY - SCIENCE?- CUET (UG) - 2023
- Computer Science
- Relational Algebra
- Which of the following statement(s) is/are true?
A. Selection operation yields horizontal subset of a relation.
B. Selection operation yields vertical subset of a relation.
C. Union operator can work on relation with different degree.
D. Intersection and Cartesian product operations are not binary.
E. A record is a column on a datasheet.- CUET (UG) - 2023
- Computer Science
- Relational Algebra
Questions Asked in CUET exam
In a sequence of numbers, each term is generated by multiplying the previous term by 2 and then subtracting 1. If the first term is 3, what is the fourth term in the sequence?
- CUET (UG) - 2025
- Data Interpretation
The following data shows the number of students in different streams in a school:
Which type of graph is best suited to represent this data?- CUET (UG) - 2025
- Income and Employment
- A projectile is fired with an initial velocity \( u \) at an angle \( \theta \) to the horizontal. The time of flight is \( T \). What is the maximum height \( H \) reached by the projectile?
- CUET (UG) - 2025
- Projectile Motion
- If DOOR is coded as EPPQ, then how is FISH coded?
- CUET (UG) - 2025
- Coding Decoding
- A person walks 10 m North, then turns right and walks 5 m, then turns right again and walks 10 m. What direction is he facing now?
- CUET (UG) - 2025
- Direction sense
View More Questions