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
Benefits of Sequential File Organisation It is quick and efficient when dealing with huge volumes of data that require being processed periodically (batch system). Dra

Define Database layer? The database layer defines the data formats used in the database.

Explain the disadvantages of file oriented approach? In the oriented approach Applications are designed in isolation. Design of application is optimized for one application. In

Explain ER Relationship model? An entity-relationship model (ERM): An entity-relationship model (ERM) is an abstract theoretical illustration of structured data. Entity-relatio

Define canonical cover? A canonical cover Fc for F is a set of dependencies like F logically implies all dependencies in FC and Fc logically shows all dependencies in F.

what is bogus empowerment. And what is genuine empowerment

What are the two types of indices? The two types of indices are:- A)     Dense index B)      Sparse index

We face problem of stock Opening balance and closing balance in Minus

#Use the following database schema: 1) Patient—PatientID, Name, DOB 2) Doctor—DoctorID, Name, MedLicenseNumber, Phone 3) Medication—MedicationID, BrandName, GenericName 4) Prescrip

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