Chapter 5, Problem 5.9RQ

Explanation of Solution

Three type of binary relationships:

The binary relationship consists of three types. They are:

• One-to-one relationship (1:1)
• One-to-many relationship (1:N)
• Many-to-many relationship (N:M)

One-to-one relationship (1:1):

• The simplest type of a binary relationship is one-to-one relationship is one of the types of binary relationship that refer to the relationship between two entities which means one field or record in a table has either zero or one field or record in another table.
• Let us consider the example:
  • In a college database, each department has only one HOD (Head of Department) and each HOD is assigned to only one department...