Chapter 2, Problem 2.36RQ

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.

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

Assumption 4:

(PetName, Date)  → (Service, Charge)

In the above expression, the last functional dependency assumes a pet is seen at most on one day, and that there is no standard charge for a service.

• The Service and Charge attribute are functionally dependent on the composite (PetName, Date)...