Explain the following relational algebra operations with proper examples i. Left outer join ii. Division iii. Rename iv. Outer join v. Project

3.6kviews

written 9.0 years ago by

meghalikalyankar • 2.3k

modified 4.0 years ago by

binitamayekar ★ 6.7k

database management systems

ADD COMMENT EDIT

1 Answer

31views

written 9.0 years ago by

meghalikalyankar • 2.3k

Left Outer Join:

In left outer join all the tuples of left relation remain part of the output. The tuples that gave a matching tuple in the second relation do have the corresponding tuple from the second relation.
However, for the tuples of the left relation, which do not have …

Create a free account to keep reading this post.

and 3 others joined a min ago.

ADD COMMENT EDIT

Please log in to add an answer.