Awesome q2a theme
0 votes
16 views



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)
0
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
14,322 comments
95,780 users