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

How do you find the final model after iterative analysis, How do you find t... How do you find the final model after iterative analysis? Why is iterative analysis of any of the problem needed? The final model serves as the base for system architectur

What is inheritance, What is inheritance? Define it in detail?  Inheri... What is inheritance? Define it in detail?  Inheritance Inheritance can be at the levels of types, or at the level of tables we first consider inheritance of types, then i

What is a recovery scheme, What is a recovery scheme? An integral part ... What is a recovery scheme? An integral part of a database system is a recovery scheme that can restore the database to the reliable state that existed before the failure.

ER-diagram, The State of NewYork certifies firefighters throughout state an... The State of NewYork certifies firefighters throughout state and keep track all of them, as well as of the state’s fire departments. Each fire department has unique department numb

BI, (a) Why did SAP introduce the extended star schema? (a) Why did SAP introduce the extended star schema?

Write short notes on domain relational calculus, Write short notes on domai... Write short notes on domain relational calculus   The domain relational calculus uses domain variables that take on values from an attribute domain rather than values for whole

Distributed database management system, Question (a) Differentiate betw... Question (a) Differentiate between the following terms: (i) Distributed Database v/s Distributed Database management System (ii) Homogeneous Distributed Database v/s Hete

Discuss the method for a hash file to expand shrink dynamic, Discuss the me... Discuss the methods for a hash file to expand and shrink dynamically. What are the advantages and disadvantages of each? The hashing methods that permit dyanamic file expansi

Compare the two log based recovery schemes, Compare the two log-based recov... Compare the two log-based recovery schemes in terms of ease of implementation and overhead cost.    Ans:  There are two types of log based recovery techniques: deferred update

ERD, online eductional management system ke diagram online eductional management system ke diagram