Explain the following relational algebra operations with proper examples

3.4kviews

written 8.8 years ago by

teamques10 ★ 69k

modified 2.5 years ago by

yashbeer ★ 11k

The terms are

i. Left outer join

ii. Division

iii. Rename

iv. Outer join

v. Project

database management systems

ADD COMMENT EDIT

1 Answer

30views

written 8.8 years ago by

teamques10 ★ 69k

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 2 others joined a min ago.

ADD COMMENT EDIT

Please log in to add an answer.