Practice$-$Class $2$

Please complete the following activity and submit one MS Word document with your solution:

Consider the following relation:

Pet $($Pet#$,$ PetName, AmountOwed, HandleriD, HandlerName, WalkCode, Walklnfo, HandlerWalkFee, WalkDate$)$

This relation concerns data about pets sheltering at the Humane Society and their handlers $($employees and volunteers$)$ who take them for a walk. The following dependencies exist in the Pet Entity:

Pet# $$ PetName, AmountOwed, HandleriD, HandlerName

HandlerlD $$ HandlerName

WalkCode $$ WalkInfo, HandlerWalkFee

Pet#$,$ HandleriD, WalkCode $$ WalkDate

QUESTIONS $($to be answered each separately, please use MS word and attach below when submitting$)$:

Convert Pet to $1$NF $($First Normal Form$)$ based on the functional dependencies given.

Convert to a set of relations in $3NF($Third Normal Form$).$

Answer: the database design needs to include an Attribute for the date of the Pet's last walk. In which Entity$/$Table would vou olace this Attribute, and whv$?$