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

BOGUS VS GENUINE EMPOWERMENT, what is bogus empowerment. And what is genuin... what is bogus empowerment. And what is genuine empowerment

What are the advantages of logical databases, What are the advantages of Lo... What are the advantages of Logical Databases? It offers a simple-to-use selection screens.  You can change the pre-generated selection screen to your needs.  It offers check f

Explain what is relation, Explain What is Relation? A database relatio... Explain What is Relation? A database relation is a predefined row or column format for storing information in a relational database. Relations are equal to tables.

Describe the ways for selecting data structure, Ways for Selecting Data Str... Ways for Selecting Data Structure Algorithms operate on data structure. Therefore, selection of the best algorithm means selecting the best data structure from whole bunch. Th

Define deadlock recovery measures, Define Deadlock recovery measures       ... Define Deadlock recovery measures                   To recover from deadlock, the cycle in the wait-for-graph should be broken. The common technique of doing this is to rollbac

Hierarchical data representation model, Examples:- Hierarchical Model: I... Examples:- Hierarchical Model: It tells data as and relationships by hierarchy of data values. Figure illustrates an example of hierarchical model. Now a day's these models are

Managing databases, 10A.53 Code an Oracle Database trigger to enforce the... 10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the

Which element in the database can modified by changing, Which element in th... Which element in the database can modified by changing the data dictionary? Data elements in the database can be changed or modified through changing the data dictionary.

Insert into command, INSERT INTO command : Values can be inserted fo... INSERT INTO command : Values can be inserted for all columns or for the selected columns Values can be given by sub query. In place of values parameter substitution

RDBMS, what is RDBMS? how it works? good example. what is RDBMS? how it works? good example.

Write Your Message!

Name