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

Improved performance, Improved performance: As the data is located near the... Improved performance: As the data is located near the site of its demand, and given the inherent parallelism because of multiple copies, speed of database access may be good for di

Define the normalisation form, Define in which normalisation form if an att... Define in which normalisation form if an attribute of a composite key is dependent on an attribute of other composite key. Ans: 3NF A relation is in 3 NF if an attribute of

What is indexed sequential file organization, What is indexed sequential fi... What is indexed sequential file organization? What are the applications of this organization?  Ans: An index file can be employed to effectively overcome the problem of storing

Removing a synonym, Removing a Synonym: DROP SYNONYM D30; Removing a Synonym: DROP SYNONYM D30;

Er diatgrams, Ask q“A database will be made to store information about pati... Ask q“A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded wher

In a hierarchical model of data records are organized, In a Hierarchical mo... In a Hierarchical model of data records are organized ? In the hierarchical model of data records are organized as Tree structure.

A basic model of database access control, A basic model of Database Access ... A basic model of Database Access Control Models of database access control have grown out of previous work on protection in operating systems. Let us talk about one simple mode

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

Design a large scale system, Question: (a) Why is it important to know... Question: (a) Why is it important to know the architecture rather than to start requirement capture when designing a large scale system? (b) Who are the different people in

Consistency, what do you mean by consistency in rdbms? what do you mean by consistency in rdbms?

Write Your Message!

Name