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 deadlock prevention, Define Deadlock prevention These protocols... Define Deadlock prevention These protocols make sure that the system will never enter a deadlock state. There are two methods to deadlock prevention. One approach makes sure t

Entity relationship model, define attribute inheritance with example? define attribute inheritance with example?

Explain displaying an er schema as an er diagram, Explain the conventions f... Explain the conventions for displaying an ER schema as an ER diagram? An E-R Diagram scheme might describe certain constraints to that the contents of a database must conform.

Backward recovery (undo), Backward Recovery (UNDO): In this system the unco... Backward Recovery (UNDO): In this system the uncommitted changes made by a transaction to a database are undone.  Instead the system is reset to the last consistent state of databa

Recovery management component, Ask question #Minim 100 words accepted#what ... Ask question #Minim 100 words accepted#what is recovery management component in database management system and how it is useful

ER DIAGRAM, draw ER diagram of student entity and course entity where attri... draw ER diagram of student entity and course entity where attribute of student entity are student roll, student name, student phone and student address and attribute of course enti

Express the subsequent query in sql assumes, Express the subsequent query i... Express the subsequent query in SQL assumes which the data is stored within EMPLOYEE table with relevant fields (i) Display name, job, salary, and hire date of employee who are

What is rdbms terminology for a row, What is RDBMS terminology for a row? ... What is RDBMS terminology for a row? A tuple is a RDBMS terminology for a row

MS Access 2010 - Form Updates Table, Hi there, Have an issue with my Databa... Hi there, Have an issue with my Database. I have: TblOrderDetails and FmOrderDetails TblCircuit and FmCircuit Whenever I add data into the Form, it will update the table as expect

Er diagrams, in an organization several projects are undertaken. Each proje... in an organization several projects are undertaken. Each project can employ one or more employees. Each employee can work on one or more projects. Each project is undertaken on the

Write Your Message!

Name