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

Update Anomaly : This anomaly is occurred due to data redundancy. Redundant information makes updates more complex since, for example, varying the name of the instructor of MCS-014

i need help for assignment ..

Using SQL create a view RS for the relations R and S. The view consists of the columns A and D renamed as X and Y in that order. Insert a tuple into it. Show the contents of t

Create student database and retrieve course name taught by king? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (secti

Describe file organisation? A file is organized logically as a sequence of records. These records are mapped onto disk blocks. A) Fixed-Length Records Type deposit=record

You will be analysing a set of financial data of your choice. It is not necessary to collect any primary data of your own, and publicly available secondary data will be sufficient

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

With the help of an example display how records can be deleted and updated in QBE. (i) Increase Pay_Rate of employees along with the skill of ‘cook' by 10%. (ii) Delete employee

What are the components of storage manager? The storage manager components include a) Authorization and integrity manager b) Transaction manager c) Buffer manager d