Chapter 5, Problem 5.12RQ

Explanation of Solution

The method for obtaining data:

After showing the two way of representing the 1:1 relationship in question 5.11 then creates a method for obtaining data about one of the entities given the key of the other.

To go from “HOD” table to “Department” table:

• The first way representing the 1:1 relationship is placing “HOD_ID” into the “Department” table as a foreign key. So, look up the “HOD_ID” in “Department” table.
• The second way is placing “Dep_ID” into the “HOD” table as a foreign key and uses the “HOD_ID” to get the row of “HOD”, then obtain “Dep_ID” from “HOD” and look up the row in “Department” using “Dep_ID” obtained...