+1 vote
183 views
Consider the following relations: $R_1(A,B,C)$ and $R_2(A,D,E)$
$R_1$ has 1000 records and $R_2$ has 2000 records. The non Null attribute $A$ is $R_2$ is referencing attribute $A$ in $R_1$. Let $X$ be minimum number of records om $R_1$ ⨝ $R_2$ and $Y$ be the maximum number of records in $R_1$⨝$R_2$. The sum of $(X+Y)$ is _______.
closed with the note: Duplicate question only difference in names of attributes and X + Y being asked here instead of X + 2Y .The link is : http://gateoverflow.in/75165/joining
closed | 183 views