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

Define single valued and multivalued attributes, Define single valued and m... Define single valued and multivalued attributes. Single valued attributes: attributes with a single value for a particular entity are known as single valued attributes. Mult

Explain forms based and graphical interface, Explain forms based and graphi... Explain forms based and graphical interface? Forms based and graphical interface: graphical user interface (GUI) is a kind of user interface which permits people to interact

Top down method and bottom up method, Evaluate, compare and contrast the tw... Evaluate, compare and contrast the two methods of relational database design namely top down method and Bottom up method. What will be your choice if you are asked to select a meth

What is known as sequential file organization, What is known as sequential ... What is known as sequential file organization? In the sequential file organization, the records are kept in sequential order, according to the value of a "search key" of every

School portal design and development, Project Description: This is going... Project Description: This is going to be a School portal to handle each activities in school such as, School fees payment, online registration and every other payment, course re

File organisation, Define reference file Define reference file

How is concurrency identified, How is concurrency identified? Concurren... How is concurrency identified? Concurrency in objects can be identified by the way they alter their state. Current objects can change their state independently. Aggregation imp

Describe the most important classes of parallel machines, Question 1 Discu... Question 1 Discuss the classification of DBMS based on location of database Question 2 Explain with examples different SQL commands used for creating and deleting relations.

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

Differentiate between primary and secondary storage, Differentiate between ... Differentiate between Primary and secondary storage? Primary and secondary storage - Primary storage device stores the data temporarily. Primary storage is commonly used thro

Write Your Message!

Name