Question

Given the following relations:

Table A

Name	Hobbies
Anu	Dance
Anuj	Music

TableB

Name	Hobbies
Prannav	Reading
Anuj	Music

Find \( \text{TableA} \cup \text{TableB} \).

• A.

  

• B.

  

• C.

  

• D.

  

Hint:

In relational algebra, \(\cup\) keeps all unique tuples across both relations. Always check for duplicates and remove them in the final result.

Answer 1

The Correct Option is A

Step 1: Recall union property.
The union of two relations includes all tuples that appear in either relation, but removes duplicates.
Step 2: Combine TableA and TableB.
From TableA: \[ \{(\text{Anu}, \text{Dance}), (\text{Anuj}, \text{Music})\} \] From TableB: \[ \{(\text{Prannav}, \text{Reading}), (\text{Anuj}, \text{Music})\} \]
Step 3: Apply union and remove duplicates.
Combining both sets, we get: \[ \{(\text{Anu}, \text{Dance}), (\text{Anuj}, \text{Music}), (\text{Prannav}, \text{Reading})\} \] Notice that \((\text{Anuj}, \text{Music})\) is duplicated, so it is kept only once.
Step 4: Match with options.
The correct table is: \[ \begin{array}{|c|c|} \hline \text{Name} & \text{Hobbies}
\hline \text{Anu} & \text{Dance}
\text{Anuj} & \text{Music}
\text{Prannav} & \text{Reading}
\hline \end{array} \]
Final Answer: \[ \boxed{\text{Option 1 is the result of } TableA \cup TableB} \]