Ads
related to: relation example algebra
Search results
Results From The WOW.Com Content Network
In mathematics and abstract algebra, a relation algebra is a residuated Boolean algebra expanded with an involution called converse, a unary operation.The motivating example of a relation algebra is the algebra 2 X 2 of all binary relations on a set X, that is, subsets of the cartesian square X 2, with R•S interpreted as the usual composition of binary relations R and S, and with the ...
A function that is injective. For example, the green relation in the diagram is an injection, but the red, blue and black ones are not. A surjection [d] A function that is surjective. For example, the green relation in the diagram is a surjection, but the red, blue and black ones are not. A bijection [d] A function that is injective and surjective.
The relational algebra uses set union, set difference, and Cartesian product from set theory, and adds additional constraints to these operators to create new ones.. For set union and set difference, the two relations involved must be union-compatible—that is, the two relations must have the same set of attributes.
In practical terms, if a relation is thought of as a table, then projection can be thought of as picking a subset of its columns. For example, if the attributes are (name, age), then projection of the relation {(Alice, 5), (Bob, 8)} onto attribute list (age) yields {5,8} – we have discarded the names, and only know what ages are present.
A relation R is called intransitive if it is not transitive, that is, if xRy and yRz, but not xRz, for some x, y, z. In contrast, a relation R is called antitransitive if xRy and yRz always implies that xRz does not hold. For example, the relation defined by xRy if xy is an even number is intransitive, [13] but not antitransitive. [14]
R is a relation; a and b are attribute names; b is an attribute of R; The result is identical to R except that the b attribute in all tuples is renamed to a. [1] For an example, consider the following invocation of ρ on an Employee relation and the result of that invocation:
Using composition of relations, the converse may be composed with the original relation. For example, the subset relation composed with its converse is always the universal relation: ∀A ∀B ∅ ⊂ A ∩B ⇔ A ⊃ ∅ ⊂ B ⇔ A ⊃ ⊂ B. Similarly, For U = universe, A ∪ B ⊂ U ⇔ A ⊂ U ⊃ B ⇔ A ⊂ ⊃ B.
Another form of composition of relations, which applies to general -place relations for , is the join operation of relational algebra. The usual composition of two binary relations as defined here can be obtained by taking their join, leading to a ternary relation, followed by a projection that removes the middle component.