Let us now talk about the relational operations:

SELECT

The select operation is used to select few specific record from the database based on different criteria, This is a unary operation mathematically denoted as σ

Syntax:

σ  (Relation)

The Boolean expression is specified in is made of a number of clauses of the form:

or

Comparison operators in the set { ≤, ≥, ≠, =, <, <} apply to the attributes whose domains are ordered value like as integer.

---

Related Discussions:- Relational operations

Explain the difference between drop and delete, Explain the Difference betw... Explain the Difference between DROP and DELETE DELETE deletes one or more than one tuples of a particular relation from the database. DROP is employed to remove a table from th

#Attribute inheritence, what is attribute is attribute inheritance in dbms?... what is attribute is attribute inheritance in dbms?

Which model is record based logical model, Which model is record based logi... Which model is record based logical model? Network Modelis basically known as record based logical model.

Explain data abstraction, Explain data abstraction? Data abstraction Da... Explain data abstraction? Data abstraction Data abstraction is a methodology in which enables us to isolate how a compound data object is utilized from the details of how it is

Equijoin, When every condition appears with equality condition (=) only. c)... When every condition appears with equality condition (=) only. c)   Natural join (denoted by R*S) When two join attributes have the similar name in both relations. (Tha

What is an entity relationship model, What is an entity relationship model?... What is an entity relationship model?  The  entity  relationship  model  is  a  collection  of  basic  objects  known as entities  and  relationship  between  those objects. An

Update anomaly-data redundancy, Update Anomaly : This anomaly is occurred d... Update Anomaly : This anomaly is occurred due to data redundancy. Redundant information makes updates more complex since, for example, varying the name of the instructor of MCS-014

Define canonical cover, Define canonical cover? A canonical cover Fc fo... 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.

Determine the advanced modeling concepts, Determine the Advanced modeling c... 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

Explain saving derived attributes to avoid re-computation, Saving Derived A... Saving Derived Attributes to Avoid Re-computation   As discussed, "redundancy means duplication of exact data". But, if multiple copies of same data are present in the system,

Write Your Message!

Name