Consider the relation PERSON. If you want to display details of persons having age less than or equal to 30 than the select operation will be used as follows:

σ AGE <=30 (PERSON)

The resultant relation will be as shown:

PERSON_ID	NAME	AGE	ADDRESS
2	Sharad Gupta	30	Pocket 2, Mayur Vihar.

 

 

 

Note:

1)   Select operation is commutative; i.e.,

σ (σ (R)) = σ (σ (R))

Therefore, series of select can be applied in any order

2) More than one condition can be applied using Boolean operators OR & AND etc.

Posted Date: 3/6/2013 5:50:22 AM | Location : United States

Ask an Expert

Related Discussions:- Example of relational operations, Assignment Help, Ask Question on Example of relational operations, Get Answer, Expert's Help, Example of relational operations Discussions

Write discussion on Example of relational operations
Your posts are moderated

Write your message here..

Related Questions

What is 2nf, What is 2NF? A relation schema R is in 2NF if it is in 1NF... What is 2NF? A relation schema R is in 2NF if it is in 1NF and every non-prime attribute A in R is fully functionally dependent on primary key.

Hashing.., various techniques of hashing? various techniques of hashing?

Explain stand alone query language in details, Explain Stand Alone Query La... Explain Stand Alone Query Language in details? Stand alone Query Language - The query language that can be used interactively is known as stand alone query language. It does no

Speedup query processing, Speedup Query Processing: A query that includes d... Speedup Query Processing: A query that includes data at various sites can be split into sub-queries. These sub- queries can be implemented in parallel by various sites. Such parall

Explain transaction, What is transaction? Collections of operations tha... What is transaction? Collections of operations that form a single logical unit of work are known as transactions.

Primary interface between a visual basic application, Question (a) Visu... Question (a) Visual Basic is governed by an event processor. Explain the meaning of this phrase. (b) Differentiate between an general procedure and event procedure. (c)

Relational operations, Let us now talk about the relational operations: ... Let us now talk about the relational operations: SELECT The select operation is used to select few specific record from the database based on different criteria, This is a un

What are the time stamps associated with each data item, What are the time ... What are the time stamps associated with each data item? W-timestamp (Q) denotes the largest time stamp if any transaction that implemented WRITE (Q) successfully. R-timesta

What is the error handling, What is the error handling Traditionally, b... What is the error handling Traditionally, bits have been sent over line lacking any error correcting scheme in physical layer. The presence of the CPU in each modem makes it po

Define the concept of aggregation, Define the concept of aggregation.  Give... Define the concept of aggregation.  Give two examples where this concept is useful. Ans: Aggregation transforms a relationship among the objects into a higher-level object. A