Question

Analyze and explain the normalization steps for this problem: 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 > ServiceDescription, 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 three questions. Use relational notation for all relations in your answers.

I already know what the 1NF, 2NF, & 3NF are, I just need help writing and explaing the steps of normalization

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

Answer 1

(a) There is just one table. So, the table ought to right now be in 1NF . The PetID and OwnerID are primary keys.

(b)The OwnerLastName and OwnerFirstName are selective to the OwnerID. The PetName, PetType and PetBreed are PetID's unique attributes. Carrying the table into 2NF would mean maneuvering the owner into their own table.
Owner: OwnerID, OwnerName
Pet: OwnerID, PetID, PetName, PetType, PetBreed, ServiceCharge, ServiceDate and ServiceDescription

(c) The identify 3NF may look like this

Owner: OwnerID, OwnerName
Pet: OwnerID, PetID, PetName, PetType, PetBreed
Services: PetID, ServiceDescription, ServiceDate, ServiceCharge