Awesome q2a theme
0 votes

I have a doubt, How many rows will be returned when All values of R2.A will be Null….in this case number of rows Natural Join should give 0 rows ….what will be minimum number of rows???

ago in Databases by (5 points) | 16 views

1 Answer

0 votes
I think you’re correct. In fact it R2.A need not even be NULL, any non NULL values such that $R_2.A \cap R_1.A = \phi$ should be sufficient to get zero rows in my opinion.
ago by (5 points)
Yes R2.A need not to be Null but since we want to get minimum in that case it has to be NULL.
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
8,953 questions
3,113 answers
95,780 users