MHB Relational algebra - What does "in" mean and how is it different than "="?

  • Thread starter Thread starter find_the_fun
  • Start date Start date
  • Tags Tags
    Algebra Mean
AI Thread Summary
In relational algebra, "in" signifies membership, indicating that an element belongs to a set or relation. The expression σ_{car IN car}R suggests that "car" is being evaluated against a set of values within relation R. The syntax used can vary based on the context, such as the specific software or textbook referenced. Typically, atomic formulas in relational algebra involve comparisons between attributes or constants, and "car IN car" likely represents a comparison where the first "car" is an attribute and the second is a collection of values. Understanding the precise meaning of "in" requires context regarding the specific relational algebra framework being discussed.
find_the_fun
Messages
147
Reaction score
0
In relational algebra what does "in" mean?
For example
[math]\sigma_{car IN car}R[/math] where R is some relation.
 
Mathematics news on Phys.org
Do you mean:

$\displaystyle \sigma\in\mathbb{R}$ ?

If so, the "in" means "is an element of."

edit: I just noticed this is probably not what you are referring to! (Doh)
 
I mean the selection operator as described here.
 
find_the_fun said:
In relational algebra what does "in" mean?
For example
[math]\sigma_{car IN car}R[/math] where R is some relation.
The subscript after σ is a formula. The exact syntax of such formulas depends on the context (software, textbook, etc.). As Wikipedia explains, a typical case is when atomic formulas have the form xRy where x is an attribute name, y is an attribute name or a constant, R is a relation such as <, and atomic formulas are joined by logical connectives. The formula "car IN car" is probably an atomic formula. Maybe the first "car" is an attribute name and the second "car" is an array of values. For a more precise answer one needs the context.
 
Seemingly by some mathematical coincidence, a hexagon of sides 2,2,7,7, 11, and 11 can be inscribed in a circle of radius 7. The other day I saw a math problem on line, which they said came from a Polish Olympiad, where you compute the length x of the 3rd side which is the same as the radius, so that the sides of length 2,x, and 11 are inscribed on the arc of a semi-circle. The law of cosines applied twice gives the answer for x of exactly 7, but the arithmetic is so complex that the...
Back
Top