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
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? 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? Give an example to explain multiplicity? Multiplicity in association indicate number of objects participate in any relationship. For

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? 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? The Advantages of view is Data security, Derived columns and Hiding of complex queries

Define an operator that a Relational Algebra does not have Ans: Relational Algebra does not have Aggregation operators.

Example - ALTER TABLE emp MODIFY (empno NUMBER (7));


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