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

What is database files , The database files accept the actual data and ... The database files accept the actual data and are typically the biggest in size. Depending on their shape, the tables for all the user operation can go in one database file-but

Objectives of database manangement system, OBJECTIVES After going thro... OBJECTIVES After going through this unit you should be capable to: Explain the File Based system and its limitations; Explain the structure of DBMS; Explain the

Wound-wait scheme-deadlock prevention, " Wound-wait" scheme : It is based o... " Wound-wait" scheme : It is based on a preemptive method. It is based on a simple rule:                   If Ti requests a database resource that is held by Tj

Types of indexes, Types Of Indexes One of the words used during the fil... Types Of Indexes One of the words used during the file organisation is the term index. In this part, let us describe this term in more detail. We find the index of keywords

Describe embedded query language, Describe Embedded Query Language? Emb... Describe Embedded Query Language? Embedded Query Language - A query language (e.g., SQL) can be implemented in two ways. It can be used interactively or embedded within a host

Managing databases, Code an Oracle Database trigger to enforce the constrai... Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department.

Explain discretionary access control, Problem: (a) Given the following ... Problem: (a) Given the following relation: Stats(Name,Sex,Children, Occupation, Salary, Tax, Audits) Write SQL code to define the following security constraints: (i) User

What is data link layer, what is data link layer what is data link layer

Describe the term- state diagram, Describe the term- State Diagram Sta... Describe the term- State Diagram State Diagram: An object could receive a sequence of the input instructions. The state of the object can differ depending upon sequence of in

Determine advantages of merging an association into a class, What are the a... What are the advantages and disadvantages of merging an association into a class?  Advantages: i)  Less number of tables ii) Faster performance due to the fewer tables

Write Your Message!

Name