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

Difference between clustered and a non-clustered index, What are the differ... What are the difference between clustered and a non-clustered index? A clustered index is a special type of index that reorders the way records in the table are physically stor

What are uncommitted modifications, What are uncommitted modifications? ... What are uncommitted modifications? The immediate-modification technique permits database modifications to be output to the database whereas the transaction is still in the act

Managing Data in Databases, Answer SQL Queries to extract data from data ta... Answer SQL Queries to extract data from data tables and questions on mapping conceptual data models into relational data model.

Extended star schema, Northwind Pty Ltd sells a variety of food products th... Northwind Pty Ltd sells a variety of food products throughout the world. They want to use the reporting features of SAP''s Business Information Warehouse to better understand thei

BI, (a) Why did SAP introduce the extended star schema? (a) Why did SAP introduce the extended star schema?

Distributed transaction atomic-consistent-isolated, A distributed transacti... A distributed transaction consists of subtransactions that execute at different sites and access local DBMSs at those sites. For example, a distributed transaction that transfers m

What are the objectives of object design, What are the Objectives of object... What are the Objectives of object design After going through this unit, you could be able to: explain steps of object design; discuss algorithms that reduce costs;

What is database files , The database files accept the actual data and ... The database files accept the actual data and are typically the biggest in size. Depending on their shape, the tables for all the user operation can go in one database file-but

What are the aggregate objects in the data dictionary, What are the aggrega... What are the aggregate objects in the data dictionary? Views Match codes Lock objects.

Creating views with check option-data control, Creating views with check op... Creating views with check option : This option limits those updates of data values that cause records to go off the view. The following instance tells this in more detail: Examp

Write Your Message!

Name