in Databases
1,119 views
0 votes
0 votes

Find the equivalent Tuple Relational Calculus query for the following:

R ⟕ S , where R(A, B) and S(A, C) are the relations and ⟕ is the left outer join symbol in Relational Algebra.

   
   
in Databases
by
1.1k views

1 comment

0
0

1 Answer

0 votes
0 votes
R ⟕ S : {t | ∃ r $\epsilon R$ , ∃ s $\epsilon S$ (r[A]=s[A] ^ t[A]=r[A] ^ t[B]=r[B] ^ t[C]=r[C] ) $\vee$ ∃ r $\epsilon R$ ( ¬∃ s $\epsilon S$ (r[A]=s[A] ^ t[A]=r[A] ^ t[B]=r[B] ^ t[C]=null))}