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

What are the uses of odbc, What are the uses of ODBC? Under what circumstan... What are the uses of ODBC? Under what circumstances we use this technology? ODBC expose database capabilities within a standardized way to the application programmer by an ap

What is a dataset, What is a dataset? A dataset is an in-memory databas... What is a dataset? A dataset is an in-memory database that is disconnected from any regular database, but has all the significant characteristics of a regular database. Dataset

Basic set operation, These are the binary operations; i.e., each is applied... These are the binary operations; i.e., each is applied to two relations or sets. These two relations can be union compatible excluding in case of Cartesian product. Two relations R

Working and processing files, 1.  Define each of the following IN YOUR OWN ... 1.  Define each of the following IN YOUR OWN WORDS: (a)   File: (b)   Record: (c)   Field: (d)   Primary Key: (e)   Secondary Key: 2.  A travel agency wants t

Explain the concept of modeling with objects, Explain the concept of Modeli... Explain the concept of Modeling With Objects A model is a conceptual representation of a specification, design or system from a particular point of view. A modelling language

Assignment, What are the typical phases of query processing What are the typical phases of query processing

List the drawbacks of relational database system, List the drawbacks of rel... List the drawbacks of relational database system A) Repetition of data B) Inability to s certain information.

Abap/4 program, It is not possible to make an ABAP/4 program, which having ... It is not possible to make an ABAP/4 program, which having only Subroutines. False. We can make ABAP/4 program, which having only Subroutines.

What is secondary index, What is Secondary Index While making the index... What is Secondary Index While making the index, generally the index table is kept in the primary memory (RAM) and the main table, because of its size is keeps in the secondary

Give the limitations of sql authorization, Give the limitations of SQL auth... Give the limitations of SQL authorization. The code for checking authorization becomes intermixed with the rest of the application code. Implementing authorization by applic

Write Your Message!

Name