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 the union property.
The union of two relations contains all tuples from either relation, with duplicates removed.
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 yields: \[\{(\text{Anu}, \text{Dance}), (\text{Anuj}, \text{Music}), (\text{Prannav}, \text{Reading})\}\] Note that \((\text{Anuj}, \text{Music})\) appears twice and is retained only once.
Step 4: Match with options.
The resulting 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 represents } TableA \cup TableB}\]