Question:
Which relational algebra operator is equivalent to a Cartesian Product followed by a Selection condition?
कौन-सा रिलेशनल बीजगणित ऑपरेटर कार्टेशियन उत्पाद (Cartesian Product) के बाद चयन (Selection) शर्त लागू करने के समतुल्य है?
Options:
- Theta Join (\(\bowtie_\theta\))
- Natural Join (\(\bowtie\))
- Projection (\(\pi\))
- Intersection (\(\cap\))
- थीटा जॉइन (Theta Join)
- नेचुरल जॉइन (Natural Join)
- प्रोजेक्शन (Projection)
- इंटरसेक्शन
Correct Answer: a)
Explanation:
By definition, a Theta Join \(R \bowtie_\theta S\) is defined as \(\sigma_\theta(R \times S)\), which is a Cartesian Product followed by a Selection operation with condition \(\theta\) (Option a).
थीटा जॉइन (Theta Join) की परिभाषा ही \(\sigma_\theta(R \times S)\) होती है (कार्टेशियन गुणन और फिर चयन) (विकल्प a)।