Database Reference
In-Depth Information
If we divide the
relation ModuleDay by the relation PairedModule we would get the following output rela-
tion:
4.14.10 Formal notation for the relational al-
gebra
A more formal notation for expressing operations in this formal language is presented in
the table below.
Operator
Restrict
Project
Union
Difference
Intersection
Natural join
Syntax
The restrict / select operator transforms a single relation R into resulting tuples matching
the specified condition
The project operator transforms a single relation R into a subset consisting of specified at-
tributes a
1
, . . ., a
n