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
- Pointing to a man, Rani says, "He is the son of my mother's only daughter.” How is the man related to Rani?
- CUET (UG) - 2025
- Blood Relations
- A and B can complete a task in the ratio 3:2. If together they complete the task in 20 days, how long will A alone take?
- CUET (UG) - 2025
- Time and Work
Identify the part of the sentence that contains a grammatical error:
Each of the boys have submitted their assignment on time.- CUET (UG) - 2025
- Subject-Verb Agreement
- If \( 3 \times 4 = 25 \), \( 5 \times 2 = 27 \), \( 6 \times 3 = 39 \), then what is \( 7 \times 5 = ? \)
- CUET (UG) - 2025
- Logical Reasoning
Rearrange the following parts to form a meaningful and grammatically correct sentence:
P. a healthy diet and regular exercise
Q. are important habits
R. that help maintain good physical and mental health
S. especially in today's busy world- CUET (UG) - 2025
- Sentence Arrangement
View More Questions