GATE CSE
First time here? Checkout the FAQ!
x
+1 vote
138 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
asked in Databases by Active (1.7k points)  
closed by | 138 views
update the link habib
Top Users Jan 2017
  1. Debashish Deka

    7050 Points

  2. Habibkhan

    4674 Points

  3. Vijay Thakur

    4224 Points

  4. saurabh rai

    4008 Points

  5. sudsho

    3960 Points

  6. Arjun

    3108 Points

  7. GateSet

    3088 Points

  8. santhoshdevulapally

    3004 Points

  9. Bikram

    2976 Points

  10. Sushant Gokhale

    2744 Points

Monthly Topper: Rs. 500 gift card

18,810 questions
23,779 answers
51,413 comments
20,128 users