Advertisements
Advertisements
प्रश्न
Differentiate between union and Cartesian product.
अंतर स्पष्ट करें
Advertisements
उत्तर
| Basis of Difference | Union | Cartesian Product |
|---|---|---|
| Purpose | Combines rows of two compatible relations. | Combines every row of one relation with every row of another. |
| Requirement | Both tables must have the same degree and compatible data types. | The two tables need not have the same number of columns. |
| Resultant degree | Same as the degree of either table. | Sum of the degrees of both tables. |
| Resultant cardinality | Number of distinct rows after removing duplicates. | Product of the cardinalities of the two tables. |
| Operation type | Adds records vertically. | Combines records horizontally. |
shaalaa.com
क्या इस प्रश्न या उत्तर में कोई त्रुटि है?
