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 two types of errors, What are the two types of errors? The... What are the two types of errors? The two types of errors are: a) Logical error b) System error

Lossless-join decomposition, Lossless-Join Decomposition   Let us sh... Lossless-Join Decomposition   Let us show an intuitive decomposition of a relation. We require a better basis for deciding decompositions since intuition may not always be r

Define first normal form and second normal form, First Normal Form and seco... First Normal Form and second normal form First Normal Form (1NF) A relation is said to be in 1NF if it having no non-atomic values and each row can give a unique combinat

Lack of redundancy, Lack of Redundancy We have talked about the problems o... Lack of Redundancy We have talked about the problems of repetition of information in a database. Such repetition should be stay away as much as possible. Let us state once again t

Define atomicity and aggregation, Atomicity : Either all functions are lai... Atomicity : Either all functions are laid out or none are. Users could not have to think about the effect of incomplete operations. DBMS ensures this by undoing the functions

What create when a primary key combined with a foreign key, What will be cr... What will be create when a primary key if combined with a foreign key? A primary key if combined with a foreign key it creates Parent-Child relationship between the tables that

Explain the concepts of relational data model, Explain the concepts of rela... Explain the concepts of relational data model? Relational Data Model - The relational model was first introduced through Prof. E.F. Codd of the IBM Research in the year 1970

Which components of the schema architecture proposed by ansi, What are thre... What are three components of the schema architecture proposed by ANSI/SPARC? The three component schema architecture proposed by ANSI/SPARC is as given below: External sche

ERD, entity relationship diagram about finance entity relationship diagram about finance

Explain olap and the benefits of olap, Data Mining 1. What is data mini... Data Mining 1. What is data mining? Write Data Mining applications. 2. Explain OLAP? Write the benefits of OLAP. 3. What are the key features of a Data Warehouse? 4. W

Write Your Message!

Name