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
List two restrictions that are applied on the modification (updation, insertion or deletion) of base tables through view.  Ans: The two restrictions are: 1. If a view

Determine the Advanced modeling concepts You have to follow some steps for object-oriented design. These steps for OO Design methodology are as follow:  1)  Produce objec

Types of Locks There are two necessary types of locks: Binary lock : This locking mechanism has two states for to a data item: locked or unlocked Multiple-mode loc


The Update Operations : Update operations are used for altering database values. The constraint violations faced by this operation are logically the similar as the problem faced

Explain Two phase locking protocol A transaction is consider as to follow the two-phase locking protocol if all locking operations precede the first unlock operation in the tra

The users who use easy-to-use menu are called ? The users who use easy to use menu are called as Naïve users.

define normalisation and functional dependency

These are designed to reduce the effects of a database failure and make sure a database is restored to a consistent state if a failure does arise. Manual backup/restore utilities n

How to Insert data in your table from another table? insert into e.g, To insert tuples from employee into N_emp created above, use following statement Insert into N_emp