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

ERD, A student entity type has the following attributes,name.. A student entity type has the following attributes,name..

Hospital managment sysytem, sy bcs project of hospital managment system sy bcs project of hospital managment system

Create a database for their customers, The ABC Bank authority now wants to ... The ABC Bank authority now wants to create a database for their customers. So you are requested to modify your program of Assignment A3 as follows. The main program first displa

Non-redundant cover and canonical cover, Given the following set of functio... Given the following set of functional dependencies {cf?bg, g?d, cdg?f, b?de, d?c} defined on R(b,c,d,e,f,g) a.Find a non-redundant cover. b.Find a canonical cover.

What are called jukebox systems, What are called jukebox systems? Jukeb... What are called jukebox systems? Jukebox systems have a few drives and numerous disks that can be loaded into single of the drives automatically.

Give some encryption techniques, Give some encryption techniques? A)  D... Give some encryption techniques? A)  DES  B) AES  C) Public key encryption

What is sql server agent, What is SQL Server Agent? SQL Server agent pl... What is SQL Server Agent? SQL Server agent plays a significant role in the day-to-day tasks of a database administrator (DBA). It is often overlooked as one of the major tools

How many types of users works on database, How many types of users works on... How many types of users works on database? Users are differentiated through the way they expect to interact along with the system (i) Application programmers-interact with

Types of locks, Types of Locks There are two necessary types of locks: ... Types of Locks There are two necessary types of locks: Binary lock : This locking mechanism has two states for to a data item: locked or unlocked Multiple-mode loc

Define the concept of generalization, Define the concept of generalization ... Define the concept of generalization A generalization is relationship between specific kind of thing and general thing. It is also known as "is-a-kind-of" relationship. Inher

Write Your Message!

Name