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 view? how it is related to data independence, A View may be defi... A View may be defined of as a virtual table, that is, a table that does not really exist in its own right but is instead inferred from one or more underlying base data table. T

Provide the steps involved in ethical analysis, Question : Mr. Smith Ha... Question : Mr. Smith Harry has a car manufacturing company which has recently integrated management information system. He wishes to obtain more information on ethics and socia

Determine the statement- state as location within a program, State as Locat... State as Location within a Program In this traditional approach, location of control inside a program totally defines the program state. Any finite state machine may be implem

Data analysis and design, #question benefits and limitations of data models... #question benefits and limitations of data models..

How to create values of structured type, How to create values of structured... How to create values of structured type? Constructor functions are used to make values of structured types. A function with the similar name as a structured type is a construct

Deadlock prevention, Deadlock Prevention One of the easiest approaches ... Deadlock Prevention One of the easiest approaches for avoiding a deadlock would be to obtain all the locks at the begin of the transaction. Though, this approach restricts conc

Domain constraints, Domain Constraints Domain constraints are primarily... Domain Constraints Domain constraints are primarily formed for defining the logically correct values for an attribute of a relation. The relation allows attributes of a relatio

In an e-r diagram how attributes are represented, In an E-R diagram how att... In an E-R diagram how attributes are represented ? In an E-R diagram attributes are represented in a ellipse.

What are the two main goals of parallelism, What are the two main goals of ... What are the two main goals of parallelism? Load -balance multiple small accesses, so that the  throughput of such accesses enhances. Parallelize large accesses so that the res

System analysis plannig and control, milestone assignment milestone assignment

Write Your Message!

Name