Advertisements
Advertisements
Question
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?
Short Answer
Solution
Rows: 2
Columns: 4
Explanation:
In a natural join, only the common row of the same field will be displayed; the common field is not repeated.
shaalaa.com
Using Two Relations in Query
Is there an error in this question or solution?
APPEARS IN
RELATED QUESTIONS
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.
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?
