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
Define a view and a trigger. Construct a view for the above relations that have the information about suppliers and the elements they supply. The view holds the S#, SNAME, P# , PNA

Evaluate: a.When transactions T1 and T2 are in a deadlock, one of the transactions will eventually implement to completion and let the other one continue implementation. b.

Advantages of Data Distribution The primary benefit of distributed database systems is the ability to access and share data in a reliable and efficient manner.

From SAD to OOAD (Structured Analysis and Design (SAD) to Object Oriented Analysis and Design (OOAD). We will find here how we can map various models in SAD to different model

Define database management system? Database management system (DBMS) is a set of interrelated data and a combination of programs to access those data.

under what condition log based recovery is feasible?

Why 'AS' clause is used in SQL ? 'As' clause is used for Rename operation. ‘AS' clause is used in SQL for rename operation. (e.g., SELECT ENO AS EMPLOYEE_NO FROM EMP)

What do you understand by RAID? Explain RAID Level 4 and Level5? RAID - It is stands for Redundant Array of Inexpensive Disks (as named by the inventor), or alternatively Re

Function requirement as given: 1> manage fans and likes and followings those information from facebook. twitter. google+ and linkedin etc 2> Organize the clients from email m

write a database program for concurrency transaction in a bank