Schema (Relational Algebra)

relational-algebra

Definition

Schema (Relational Algebra)

A schema $\mathcal{R}$ of a relation $R$ describes the structure of data in a relation $R$ and is denoted as $\mathrm{sch}(R)$ or as $\mathcal{R}$.

The notation is defined as follows:

$$R(A_1:D_1,A_2:D_2,\dots ,A_n:D_n)$$

where $A_i$ is an attribute of with domain $D_i$.

Example:

$$phone\_book(name:string,street:string,number:integer)$$