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

What are the advantages of object id, What are the advantages of object ID?... What are the advantages of object ID? The main advantages of Object IDs are as below: i) IDs are not changing  ii) IDs are completely independent of the changes in data v

Reasons for the growing popularity of data mining, Question: Data Minin... Question: Data Mining is the process of extracting knowledge hidden from large volumes of raw data. (a) Using a suitable example, illustrate how Data Mining can be useful t

Explain the term - adjustment of inheritance, Explain the term - Adjustment... Explain the term - Adjustment of inheritance The inheritance can be enlarged as object design progresses by changing class structure. The designer should do: i) Adjust or r

Differentiate between primary and secondary storage, Differentiate between ... Differentiate between Primary and secondary storage? Primary and secondary storage - Primary storage device stores the data temporarily. Primary storage is commonly used thro

What are the situations while dbms should not be used, What are the situati... What are the situations while DBMS should not be used? DBMS should not be used in situations like: (i) No need of security. (ii) Not difficulty to access the data (iii) N

List any two disadvantages of a database system, List any two disadvantages... List any two disadvantages of a database system ? The disadvantages of database system are: • Database systems are difficult, complex, and time-consuming to design. • Substanti

What are the key features of oracle, What are the key features of Oracle? ... What are the key features of Oracle? Key features of Oracle are as follows: • Read Consistency • Concurrency • Locking Mechanisms • Quiesce Database • RAC • Portability

Describe the major steps in the implementation process, Question: (a) ... Question: (a) One of the steps in the five-step problem-solving model is implementation. Implementation is considered a key step in the problem-solving model. A problem may be

Fundamental operations that are regular to mysql programs, What are the thr... What are the three fundamental operations that are regular to MySQL Programs? a) Establishing a connection to the MySQL server b) Choosing a database. c) Disconnecting fr

Data base design for a museum information system, In this practical assignm... In this practical assignment, we will run through a complete database application development cycle, starting with the schema design, from an initial data import to database applic