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

Sources of utilities for a dbms, There are three main sources of utilities ... There are three main sources of utilities and applications for a DBMS: a. Vendor applications and utilities are given for working with or maintaining the database, and generally

Define identify relationship, Define identify relationship? Identifyin... Define identify relationship? Identifying relationship: An identifying relationship means in which the child table cannot be uniquely recognize without the parent. For exampl

What is multiplicity in the associations, What is multiplicity in the assoc... What is multiplicity in the associations? Give an example to explain multiplicity? Multiplicity in association indicate number of objects participate in any relationship. For

What is candidate key, What is candidate key? Candidate Key - A candi... What is candidate key? Candidate Key - A candidate key of an entity set is a minimal superkey, which uniquely identifies each row in the relation.

What are stand-alone procedures, What are stand-alone procedures? Proce... What are stand-alone procedures? Procedures that are not part of a package are called as stand-alone because they independently defined. A good example of a stand-alone procedu

Which is an advantage of view, Which is an advantage of view? The Advan... Which is an advantage of view? The Advantages of view is Data security, Derived columns and Hiding of complex queries

Define an operator that a relational algebra does not have, Define an opera... Define an operator that a Relational Algebra does not have Ans: Relational Algebra does not have Aggregation operators.

Example of alter table command, Example - ALTER TABLE emp MODIFY (empno NUM... Example - ALTER TABLE emp MODIFY (empno NUMBER (7));

Explain Lock-Based protocols, # ???? .. # ???? ..

What is indexed sequential file organization, What is indexed sequential fi... What is indexed sequential file organization? What are the applications of this organization?  Ans: An index file can be employed to effectively overcome the problem of storing