Chapter 7, Problem 2PE

Explanation of Solution

Identifying the Non-trivial functional dependencies:

The given figure 7.18 depicts 3 relations.

Considering the attributes A and B,

For each value of the A there is only one value for B and it is indicated as shown below:

$\text{A }\to \text{ B}$

Considering the attributes B and C,

For one value of B there are multiple values present for C and it is not considered to be non-trivial functional dependency between them.

Similarly by considering the possible combinations of the relation the following non trivial functional dependencies can be obtained and it is shown below:

$\text{C }\to \text{ B}$

Using the above two dependencies identified, third is obtained using the union axiom and it can be logically indicat