Define the basic operations of the relational algebra?   

 Ans: Basic operators of relational algebra are:

1. Union (∪) - Selects tuples which are in either P or Q or in both of them.  The duplicate tuples are removed.

R = P ∪ Q

 2. Difference or Minus (-) - eliminates common tuples from the first relation.

R = P - Q 

3.  Cartesian Product or Cross Product (×) - The cartesian product of two relations is the concatenation of tuples that are belonging to the two relations and containing all possible combination of the tuples.

R = P× Q

 4. Projection (π) - The projection of a relation is illustrated as a projection of all its tuples over some set of attributes that is it yields a vertical subset of the relation. The relation's projection T on the attribute A is presented by T [A] or π_A(T),.

 5. Selection (σ) - Selects just some of the tuples, those satisfy specified criteria, from the relation. It yields a horizontal subset of a following relation.

R = σ_B(P)

Posted Date: 5/4/2013 1:20:58 AM | Location : United States

Ask an Expert

Related Discussions:- Define the basic operations of the relational algebra, Assignment Help, Ask Question on Define the basic operations of the relational algebra, Get Answer, Expert's Help, Define the basic operations of the relational algebra Discussions

Write discussion on Define the basic operations of the relational algebra
Your posts are moderated

Write your message here..

Related Questions

Join operation, The JOIN operation is applied on two relations. When we wan... The JOIN operation is applied on two relations. When we want to choose related tuples from two given relation join is used. The join operation need that both the joined relations m

What are the comparison operator in sql, What are the comparison operator i... What are the comparison operator in SQL?  Comparison operator in SQL are =, LIKE and BETWEEN

Give example of relational schema, An instance of relational schema R (A, B... An instance of relational schema R (A, B, C) has distinct values of A including NULL values. then A is a candidate key or not? If relational schema R (A, B, C) has distinct val

What is a view, What is a view? How it is related to data independence? ... What is a view? How it is related to data independence? A view might be thought of as a virtual table, that is, a table that does not really exist in its own right but is inste

Select statement-data manipulation language, SELECT Statement This stat... SELECT Statement This statement is used for retrieving information from the databases. It can be coupled with many clauses. Let us talk about these clauses in more detail:

List any eight applications of dbms, List any eight applications of DBMS. ... List any eight applications of DBMS. a) Universities b) Airlines c) Banking d) Credit card transactions e) Tele communication f) Sales g)Finance h) Manufac

RDBMS, DISADVANTAGES OF RDBMS DISADVANTAGES OF RDBMS

What is a transaction? and how does it differs from update, wh wh

Binary relationships, One-to-one relationship: For every 1:1 relationshi... One-to-one relationship: For every 1:1 relationship type R in the ER diagram including two entities E1 and E2 we take one of entities (say E1) preferably with total participatio

What is gathering information and producing erd, What is Gathering informat... What is Gathering information and Producing ERD Gathering information: This could be a written document that explains the system in question with reasonable quantity of detai