Union - basic set operation, Database Management System

UNION

If R1 and R2 are two union compatible relations then R3 = R1 ∪ R2 is the relation having tuples that are either in R1 or in R2 or in both.

In case, R3 will have tuples such that R3 = {t | R1 ∋ t ∨ R2 ∋ t}.

Example

R1                                                                               

 

X

Y

A1

B1

A7

B7

A2

B2

A4

B4

R2

A

B

A1

B1

A2

B2

A3

B3

A4

B4

R3 = R1 ∪ R2 is

 Q

A

B

A1

B1

A2

B2

A3

B3

A4

B4

A7

B7

 

 

Note:  1) Union is a commutative operation, i.e, R ∪ S = S ∪ R.

2) Union is an associative operation, i.e.

R ∪ (S ∪ T) = (R ∪ S) ∪ T.

Posted Date: 3/6/2013 5:43:59 AM | Location : United States







Related Discussions:- Union - basic set operation, Assignment Help, Ask Question on Union - basic set operation, Get Answer, Expert's Help, Union - basic set operation Discussions

Write discussion on Union - basic set operation
Your posts are moderated
Related Questions
Discuss The difference between drop table R and delete from R.  DROP TABLE command deletes all the records with the table definition. This command will automatically committed


Explain the ISA relationship Answer: ISA relationship - ISA notation is employed in generalization/ specialization to depict relationship among lower and higer level entity s

anyone have a textbook solutions case fair, 8 edition of vol 1 ?, please give me

What is a shadow copy scheme? It is simple, but efficient, scheme known as the shadow copy schemes. It is based on making copies of the database called shadow copies that singl

Farmer Bob, Farmer Jane and Farmer Jose run a cow farming co-op. For every cow they keep the cow’s name, age (or date of birth), breed and numbered plastic ear tag. The each of t

I need web security expert , website management Project Description: i want professional for the below . website management server management database management

What is a function group? A function group is a collection of logically related modules that share global data with every other.  All the modules in the group are contained in

The database files accept the actual data and are typically the biggest in size. Depending on their shape, the tables for all the user operation can go in one database file-but

Determine the Derived attribute to avoid re-computation Each class box consists of an ordered list of attributes and operations, each represented as a next string. We can find