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

Which method of access uses key transformation, Which method of access uses... Which method of access uses key transformation? A Hash method of access uses key transformation.

Which component is not included in database environment, Which component is... Which component is not included in database environment ? A users component is not included in database environment.

What is a data warehouse, Problem 1 What is a Data Warehouse? Mention i... Problem 1 What is a Data Warehouse? Mention its advantages 2 Explain the Top-Down and Bottom-up Data Warehouse development Methodologies 3 What is Data Transformation? Ex

Database, why are older data models are being replaced by new data models why are older data models are being replaced by new data models

Define the phases of two phase locking protocol, Define the phases of two p... Define the phases of two phase locking protocol Growing phase: a transaction may get locks but not release any lock. Shrinking phase: a transaction might be release locks bu

Explain transaction manager and their work, Explain Transaction manager and... Explain Transaction manager and their work? Transaction Manager: Ensure the database remains in a constant (correct) state despite system failure, and in which concurrent trans

Define the term database, QUESTION (a)(i) Define the term database. ... QUESTION (a)(i) Define the term database. (ii) How is it different from a database management system? (b) What is the difference between an entity and an attribute? (c

What is management system, What is Management System? A management syst... What is Management System? A management system is a set of rules and process which help us to create organize and manipulate the database. It also helps us to add, change delet

Data base administrator, What is the role of a database administrator? What is the role of a database administrator?

What are the problems in database normalization, What are the problems if o... What are the problems if one were not to normalize?  When do these problems surface?           Ans:  Database normalization, sometimes considered to as  canonical synthesis, is

Write Your Message!

Name