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

Ask an Expert

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

Write your message here..

Related Questions

Define a view and a trigger, Define a view and a trigger. Construct a view ... 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

Transactions t1 and t2 are in a deadlock, Evaluate: a.When transactions... 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, Advantages of Data Distribution The pr... 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.

Data flow diagram of structured analysis and design, From SAD to OOAD (Stru... 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, Define database management system? D... Define database management system? Database management system (DBMS) is a set of interrelated data and a combination of programs to access those data.

Log based recovery, under what condition log based recovery is feasible? under what condition log based recovery is feasible?

Why as clause is used in sql, Why 'AS' clause is used in SQL ? 'As' cla... 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, What do you understand by RAID? Explain RA... 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

Organize the clients from email marketing, Function requirement as given: ... 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

Project, write a database program for concurrency transaction in a bank write a database program for concurrency transaction in a bank