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

Type of views-data control, Type of views :  Simple views and Difficult ... Type of views :  Simple views and Difficult Views Feature Simple Views Complex Views Number of tables One

What are referential integrity constraints, What are referential integrity ... What are referential integrity constraints? A value that appears in single relation for a given set of attributes also appears for a particular set of attributes in another rel

A database administrator'', A database administrator''s responsibilities an... A database administrator''s responsibilities and data contents

Define the schema at the intermediate level of abstraction, Define Accordin... Define According to the levels of abstraction, the schema at the intermediate level is called  Ans: As per to the levels of abstraction, the schema at the intermediate level is

Sorting-stacks, 1. Identify the comparisons and exchanges made to sort the ... 1. Identify the comparisons and exchanges made to sort the following array using the selection exchange sort technique. Note: you may not need all columns. Ori

Describe the storage structure of indexed sequential file, Describe the sto... Describe the storage structure of indexed sequential files and their access method. Ans: Index offers a lookup capability to rapidly reach the vicinity of the desired record.

Apriori algorithm-find all frequent large itemsets, Your friend owns a comp... Your friend owns a computer store in Yuen Long, selling Desktop and Notebook PCs and other computer peripherals. Having been rather successful with his business there, he decided t

Normalization, Introduction In large projects, we can have many different ... Introduction In large projects, we can have many different companies working together. Generally, the project or contract is awarded to one company (Principal Contractor), which

What is enterprise resource planning, What is Enterprise Resource Planning ... What is Enterprise Resource Planning (ERP), and what kind of a database is used in an ERP application? Enterprise Resource Planning (ERP) is an information system used in manuf

Discuss the different layers of ansi sparc architecture, Q.1 Briefly discus... Q.1 Briefly discuss the different layers of ANSI SPARC architecture. Ans: The three layers of ANSI SPARC architecture are like this: 1. Internal view is at the lowest leve

Write Your Message!

Name