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

RAID technology, what characterizes the levels in RAID technology what characterizes the levels in RAID technology

Describe substring comparison in sql, Describe substring comparison in SQL.... Describe substring comparison in SQL. For the relation Person (name, address), write a SQL query that retrieves the names of people whose name starts along with ‘A' and address co

Physical dbms architecture, PHYSICAL DBMS ARCHITECTURE  The physical ... PHYSICAL DBMS ARCHITECTURE  The physical architecture defines the software components used to process and enter data, and how these software components are related and interc

Describe logical data independence, Describe logical data independence ? ... Describe logical data independence ? Logical Data Independence - It is the capacity to modify the conceptual schema without having to change external schemas or application p

Creation of indexes, Creation of Indexes Automatically: When a primar... Creation of Indexes Automatically: When a primary key or Unique constraint is show in a table definition then a unique index is formed automatically. Manually: User can

Why do so various organizations use mysql, Why do so various organizations ... Why do so various organizations use MySQL? Advantages: Open source Highly efficient Offers a high scalability in terms of size and connectivity. Highly prote

DSS, WHAT IS DSS? WRITE ITS REQUIREMENTS. WHAT IS DSS? WRITE ITS REQUIREMENTS.

DBMS, to develop elrctronic database from manual forms to develop elrctronic database from manual forms

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.

Designing the fields in the data base, Designing the fields in the data bas... Designing the fields in the data base The following are the considerations one has to remain in mind while designing the fields in the data base. Coding, compression, en

Write Your Message!

Name