Relations and fields can be renamed in relational algebra using the renaming…
2020
Relations and fields can be renamed in relational algebra using the renaming operator ______.
- A.
ρ
- B.
σ
- C.
θ
- D.
⋈
Attempted by 444 students.
Show answer & explanation
Correct answer: A
The Rename operator is denoted by the Greek letter rho (ρ). It is used to rename either the relation (table) itself or the attributes (fields) within a relation. This is particularly useful in self-joins or to avoid ambiguity. The correct option is A.