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

Design a large scale system, Question: (a) Why is it important to know... Question: (a) Why is it important to know the architecture rather than to start requirement capture when designing a large scale system? (b) Who are the different people in

Define check point and its impact on data base recovery, Define check point... Define check point and its impact on data base recovery.                  Ans:  There could be hundreds of transactions handled per minute, in a large on-line database system.

What is the use of keyword isa, What is the use of keyword ISA? The use... What is the use of keyword ISA? The use of keyword ISA is to show that a class is a specialization of another class.

Update city of first bank corporation to new delhi, Change the city of Firs... Change the city of First Bank Corporation to ‘New Delhi' UPDATE COMPANY SET CITY = ‘New Delhi' WHERE COMPANY_NAME = ‘First Bank Corporation';

.DBMS, please describe the data base management with the easy example &giv... please describe the data base management with the easy example &give the application?

Selective replication-data replication, Selective replication: This is a c... Selective replication: This is a combination of generating small fragments of relation and replicating them rather than a entire relation. The data should be fragmented on require

Define two-phase locking protocol, Define two-phase locking protocol. A... Define two-phase locking protocol. Ans: Two-phase locking is significance in the context of ensuring that schedules are serializable. The two-phase locking protocol defines a p

List any two disadvantages of a database system, List any two disadvantages... List any two disadvantages of a database system ? The disadvantages of database system are: • Database systems are difficult, complex, and time-consuming to design. • Substanti

What is the difference between primary key and a unique key, What's the dif... What's the difference between a primary key and a unique key? Both primary key and unique key enforces uniqueness of the column on which they are explained. But by default prim

List some instances of collection types, List some instances of collection ... List some instances of collection types? a) sets b) arrays c) multisets

Write Your Message!

Name