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

Atomicity-transaction , Atomicity: It describes a transaction to be a one ... Atomicity: It describes a transaction to be a one unit of processing. We can also say either a transaction will be finished completely or not at all. In the transaction example 1

Type of views-data control, Type of views :  Simple views and Difficult ... Type of views :  Simple views and Difficult Views Feature Simple Views Complex Views Number of tables One

Sequences-data control, Sequences Sequences: Automatically produ... Sequences Sequences: Automatically produce unique numbers Are sharable Are typically used to make a primary key value Replace application code Speed up t

Transaction, .#question. Discuss the problem which may arise during concurr... .#question. Discuss the problem which may arise during concurrency control and recovery in distributed database which are not encountered in controlized database environment.

Abap/4 statements to access internal tables without header, What should be ... What should be declared explicitly in the corresponding ABAP/4 Statements to access internal tables without header lines & why? Work Area. This is needed as the Work Area is

Explain embedding sql statements, Question 1 Explain the functions of t... Question 1 Explain the functions of the following Storage Manager Buffer Manager Transaction Manager 2 Discuss about system catalog in a relational DBMS 3

Database errors, Database Errors: An error is said to have occurred if the ... Database Errors: An error is said to have occurred if the implementation of a command to manipulate the database cannot be successfully finished either due to inconsistent data or

Conversion of er diagram to relational database, Conversion of entity sets:... Conversion of entity sets: I)   For  every  strong  entity  type  E  in  the  ER  diagram,  we  make  a  relation  R containing all the easy attributes of E. The relation R pri

Database Management System, Assume that you are responsible for selecting a... Assume that you are responsible for selecting a new DBMS product for Sohar Hospital

Adding redundant associations for efficient access, Adding Redundant Associ... Adding Redundant Associations for Efficient Access Redundant associations do not add any type of information, therefore during design we should actually examine structure of o

Write Your Message!

Name