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

Two approaches to store relations in distributed database, What are the two... What are the two approaches to store relations in distributed database? a) Replication b) Fragmentation

What is outer join, What is Outer join?  They can be employed while we ... What is Outer join?  They can be employed while we want to keep all the tuples in R, or all those in S or all those in both relations in the result of the JOIN in spite of of w

Data storage and retrieval services, An Enterprising group of Entrepreneurs... An Enterprising group of Entrepreneurs introduced a new business named StoreItRite which is based on data storage and retrieval services. It provides the services and the company c

Implementation of integrity rules, Question 1 Describe the following- ... Question 1 Describe the following- Clustering Indexing Question 2 Explain the following with suitable real time examples- Implementation of Integrity rules

What is catalog in dbms, What is catalog in DBMS? Catalog - A relationa... What is catalog in DBMS? Catalog - A relational DBMS maintains information about every table and index in which it contains. A catalog is a collection of special tables that st

Sparse and dense indexes, Sparse and Dense Indexes These indexes in pri... Sparse and Dense Indexes These indexes in principle are the similar as that of indexes used at the back of the book. The key facts of the indexes are: They are arranged

In e-r diagram how generalization is represented, In E-R diagram how genera... In E-R diagram how generalization is represented? in E-R diagram generalization is represented by Triangle shape.

Higher software development cost, Drawbacks of Data Distribution: The prim... Drawbacks of Data Distribution: The primary drawbacks of distributed database systems are the added complexity needed to ensure proper coordination between the sites. This increas

What are the factors into account when choosing a raid level, What are the ... What are the factors to be taken into account when choosing a RAID level? A) Monetary cost of extra disk storage requirements. B) Performance requirements in terms of number

Homework, database help database help