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

When it is better to use files than a dbms, When It is better to use files ... When It is better to use files than a DBMS? It is better to use files than a DBMS when Multiple users wish to access the data.

Union - basic set operation, UNION If R1 and R2 are two union compatibl... UNION If R1 and R2 are two union compatible relations then R3 = R1 ∪ R2 is the relation having tuples that are either in R1 or in R2 or in both. In case, R3 will have tuples

Data base design for a museum information system, In this practical assignm... In this practical assignment, we will run through a complete database application development cycle, starting with the schema design, from an initial data import to database applic

How nulls are treated in comparison operator, How nulls are treated in comp... How nulls are treated in comparison operator? Along with comparison (relational) operators, the null values are ignored as we cannot derive the relation along with the given op

Differentiate between static hashing and dynamic hashing, Differentiate bet... Differentiate between static hashing and dynamic hashing.  Ans: Static Hashing comprises the number of primary pages in the directory fixed. So, while a bucket is full, we requ

Atomicity-transaction , Atomicity: It describes a transaction to be a one ... Atomicity: It describes a transaction to be a one unit of processing. We can also say either a transaction will be finished completely or not at all. In the transaction example 1

Insert - referential integrity, The insertion of a tuple in the aim of refe... The insertion of a tuple in the aim of reference does not cause any destruction. Though, insertion of a tuple in the relation in which, we has the foreign key, for instance, in ASS

System analysis and Design, difference between MIS and DSS difference between MIS and DSS

Project, I need help in doing my dbms project I need help in doing my dbms project

Implementation of database, The ER diagram clearly showing the additional t... The ER diagram clearly showing the additional tables you have implemented. SQL table creation scripts for the tables you have set up. SQL scripts showing the sample data you

Write Your Message!

Name