Advertisements
Advertisements
प्रश्न
In MYSQL database, if a table, Alpha has degree 5 and cardinality 3, and another table, Beta has degree 3 and cardinality 5, what will be the degree and cardinality of the Cartesian product of Alpha and Beta?
पर्याय
5, 3
8, 15
3, 5
15, 8
MCQ
उत्तर
8, 15
Explanation:
In case of Cartesian product, Degree of resultant is D1 + D2, and Cardinality is C1 × C2.
shaalaa.com
Using Two Relations in Query
या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
APPEARS IN
संबंधित प्रश्न
Which of the following join selects all rows from both the tables as long as the condition satisfies?
A ______ is a join of every row of one table to every row of another table.
Consider the following tables – LOAN and BORROWER:
Table: LOAN
| LOAN_NO | B_NAME | AMOUNT |
| L-170 | DELHI | 3000 |
| L-230 | KANPUR | 4000 |
Table: BORROWER
| CUST_NAME | LOAN_NO |
| JOHN | L-171 |
| KRISH | L-230 |
| RAVYA | L-170 |
How many rows and columns will be there in the natural join of these two tables?
