Example of relational operations, Database Management System

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







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
Related Questions
Construct an ER diagram for a hospital along with a set of patients and a set of medical doctors Associate with every patient a log of the several tests and examinations conducted.

Project Description: I am having a random problem with my Wordpress site. If I click on "Publish" and "Add new", it takes me to a 404 page not found of /wp-admin/post.php (th

When are they useful? Justify with an example. The temporary tables are commonly used to support specialized rollups or exact application processing needs. Unlike a permanent t

er diagtram for icici

Provide Examples of different types of Time and Date formats.  It's most common store dates using a dash (-) as a colon (:)and the delimiter as the time delimiter. The given fo

Explain the main advantages of DBMS over File Oriented System ?


Describe the benefits of OOD techniques OOD techniques are very useful for development of large and complex systems. It has been noted that large projects that are developed u

What is Trigger? A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are kept in and managed by the DBMS. Triggers a

The technique of converting the state diagram to code a) Identify all major control paths. Start from initial state; choose a path across the diagram that corresponds to normal