The following is the relation notation of the Veterinary Office List.

VETERINARY_OFFICE (PetID, PetName, PetType, PetBreed, OwnerID, OwnerLastName, OwnerFirstName, ServiceDescription, ServiceDate, ServiceCharge)

The functional dependencies are given below:

PetID -> PetName, PetType, PetBreed, OwnerID, OwnerLastName, OwnerFirstName

OwnerID -> OwnerLastName, OwnerFirstName

ServiceDescription -> ServiceCharge

PetID, ServiceDate -> ServicedDescription, ServiceCharge

Assumption: A pet belongs to only one owner, while an owner may have more than one pet. A pet receives at most one treatment on any given date.

Use the functional dependencies above to answer the following questions. Use detail steps or intermediate steps to answer the questions

A. Show the 1NF in relational notation and indicate the primary key.

B. Show all partial dependency in the relation only (if any) and identify the 2NF. Show primary keys and foreign keys references. Use relational notation.

C. Show all transitive dependency in your answer to question b (if any) and identify 3NF (show all relations). Show primary keys and foreign keys references. Use relational notation