Memory Based GATE DA 2024 | Question: 47

You are given three tables: `team`, `table1`, and `table2`. To find the names of all players in the team who are either present in `table1` or `table2`, consider the following relational algebra queries:
 

1. \(\Pi_{\text{{PlayerName}}}(\text{{team}}) \,/\, \Pi_{\text{{Name}}}(\text{{table1}} \cup \text{{table2}})\)
       
2. \(\Pi_{\text{{PlayerName}}}(\text{{team}}) \,/\, \Pi_{\text{{Name}}}(\text{{table1}} \cap \text{{table2}})\)
    
3. \(\Pi_{\text{{Name}}}(\text{{table1}} \cup \text{{table2}}) \,/\, \Pi_{\text{{PlayerName}}}(\text{{team}})\)
       
4. \(\Pi_{\text{{Name}}}(\text{{table1}} \cap \text{{table2}}) \,/\, \Pi_{\text{{PlayerName}}}(\text{{team}})\)