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:






Sharad Gupta


Pocket 2, Mayur






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
Consider the following relational scheme: R (a,b,c,d,e,f) and its corresponding set of FDs {d→ a, be → c, ac → e, b → f, f → d, a → c}. a. Is the following decomposition i) non

Differentiate OO development from structured development. Structured approach of problem solving is based upon the idea of decomposition of system into subsystem. In this appro

How is the database organised in Oracle? Database organized within Oracle in terms of table and table holds attributes and values. A database consists of one or more logical

wrie a report on whether a BSc n information systems develops the skills required by employers in Database administration

What is a view? A view is a logical view on one or more tables.  A view on one or more tables i.e., the data from a view is not actually physically kept instead being derived f

My cut off date is very soon in a Database subject and i dont know how to solve anything in it

Database Manager It is the interface among low-level data, queries and application programs. Databases typically need a large amount of storage space. It is kept on disks, as

As with other software, databases can potentially be used for unethical purposes. As a database developer, and a consumer, you should recognize database misuse, and how it may affe

Define garbage collection. Garbage may be formed also as a side effect of crashes. Periodically, it is essential to find all the garbage pages and to add them to the list of fr