Chapter 7, Problem 3PE

Explanation of Solution

Identifying the functional dependencies:

The relationship sets can be indicated using the functional dependencies.

One-to –one relationship:

The one-to-one relationship between the given entities can be identified using the functional dependencies:

• The primary key attribute of the relation r can be denoted as ${\text{P}}_{\text{K}}\left(\text{r}\right)$
• The below two functional dependencies together denotes:

$\begin{array}{l}{\text{P}}_{\text{k}}\left(\text{student}\right)\to {\text{P}}_{\text{k}}\left(\text{instructor}\right)\\ {\text{P}}_{\text{k}}\left(\text{instructor}\right)\to {\text{P}}_{\text{k}}\end{array}$