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

Describe query evaluation engine, Describe Query evaluation engine? Que... Describe Query evaluation engine? Query Evaluation engine: Vehicle executes low-level instructions obtained through the DML compiler. The Storage Manager Components gives in

Drawbacks of database systems, Drawbacks of Database systems ? Drawbacks of Database systems ?

Relational constraints, Relational and E-R Model There are three types o... Relational and E-R Model There are three types of constraints on relational database that have: DOMAIN CONSTRAINT PRIMARY KEY CONSTRAINT INTEGRITY CONSTRAINT

Business process model, Consider a research paper submission process. The p... Consider a research paper submission process. The process starts when an author submits a draft research paper (the paper may have up to 3 authors) to the chair of the organizing c

How many types of locks are there, Depending upon the rules we have found, ... Depending upon the rules we have found, we can classify the locks into two types. Shared Lock: A transaction might be acquiring shared lock on a data item in order to read it

Give a sample of the dynamic model, Give a sample of the Dynamic Model. ... Give a sample of the Dynamic Model. The sample of dynamic model is given below:  Dynamic model for the car: Brake and Accelerator            Brake or Applies Accelerator

I need erp system, I need ERP system We are selling automotive spare par... I need ERP system We are selling automotive spare parts on the internet and we require ERP software, which would sync with our e-shop. Our e-shop doesn't use any e-commerce plat

In which relational modes cardinality is termed, In which relational modes,... In which relational modes, cardinality is termed? Answer : Cardinality is termed in a number of tuples relational modes.

Relational schema, crete a data base relationship model Entity: ... crete a data base relationship model Entity: Students; Professors; Dormitories buildings; Attributes of students: Name; Address; Dorm;

Data control, Data Control The data control mostly refers to commands that... Data Control The data control mostly refers to commands that permit system and data privileges to be passed to several users. These commands are usually available to database admi