Chapter 19, Problem 16E

Explanation of Solution

Example of the relational schema:

R ^' is considered as the relational schema.

F ^'is considered as the functional dependency.

Relational schema:

${\text{R}}^{\text{'}}\text{=}\left(\text{A,B,C,D,E}\right)$

Functional dependency:

${\text{F}}^{\text{'}}\text{= A}\to \text{B,C}\to \text{D,B}\to \text{C}$

Three distinct lossless join decomposition of R ^'into BCNF (Boyce Code Normal Form) are:

$\begin{array}{l}{\text{R}}_{\text{1}}\text{=}\{\left(\text{A,B}\right)\text{,}(\end{array}$