Chapter 2, Problem 2.33RQ

Explanation of Solution

Determinant in following relation:

Assumption 1:

PetName → (PetType, PetBreed, PetDOB, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail)

In the above expression, PetName attribute determines PetType, PetBreed, PetDOB, OwnerLastName, OwnerFirstName, OwnerPhone, and OwnerEmail attributes, left term “PetName” refers the determinant, and “→” defines the relationship.

• That is, the PetType, PetBreed, PetDOB, OwnerLastName, OwnerFirstName, OwnerPhone, and OwnerEmail are functionally dependent on PetName.

Therefore, the “PetName” is the determinant for this assumption.

Assumption 2:

OwnerEmail → (OwnerLastName, OwnerFirstName, OwnerPhone)

In the above expression, OwnerEmail attribute determines OwnerLastName, OwnerFirstName, and OwnerPhone attributes, left term “OwnerEmail” refers the determinant, and “→” defines the relationship.

• That is, the OwnerLastName, OwnerFirstName, and OwnerPhone are functionally dependent on OwnerEmail.

Therefore, the “OwnerEmail” is the determinant for this assumption.

Assumption 3:

OwnerPhone → (OwnerLastName, OwnerFirstName, OwnerEmail)

In the above expression, OwnerPhone attribute determines OwnerLastName, OwnerFirstName, and OwnerEmail attributes, “OwnerPhone” refers the determinant, and “→” defines the relationship.

• That is, the OwnerLastName, OwnerFirstName, and OwnerEmail are functionally dependent on OwnerPhone...