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

Describe the basic steps involved in recovery, Question: One of the tas... Question: One of the tasks a database management system must perform is to ensure that the data is still intact in the face of software and hardware failure. This task is known

Concept of foreign key, Fundamentals of Database Management 1. Explai... Fundamentals of Database Management 1. Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? 2. With a necess

Generalization, what is completeness constrent? what is completeness constrent?

Query to delete constraint from alter table, A constraint named less_than_2... A constraint named less_than_20 was defined on the field date_of_birth of table student. Delete this constraint. ALTER TABLE student DROP CONSTRAINT less_than_20;

Determine object representation, Determine object representation As a ... Determine object representation As a designer, we must choose properly that when to use primitive types in representing objects and when to combine groups of related objects,

Explain the b+ tree, Explain the B + tree? B + tree is a type of tre... Explain the B + tree? B + tree is a type of tree which denotes sorted data in a way that permits for efficient insertion, retrieval and removal of records, each of which is

Relational database, Convert the following ER - diagram (Entity Relationsh... Convert the following ER - diagram (Entity Relationship Diagram) into a relational database (the primary keys are underlined): 2160_Convert the following ER - diagram into a

What are the comparison operator in sql, What are the comparison operator i... What are the comparison operator in SQL?  Comparison operator in SQL are =, LIKE and BETWEEN

Business process model, Consider a research paper submission process. The p... Consider a research paper submission process. The process starts when an author submits a draft research paper (the paper may have up to 3 authors) to the chair of the organizing c

Data mining objective, State your technical objectives for mining the data.... State your technical objectives for mining the data. Data Understanding. Describe the data For each attribute, give its description and data type. For numeric attributes

Write Your Message!

Name