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, WalkInfo, 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

HandlerID $-->$ HandlerName

WalkCode $-->$ WalkInfo, HandlerWalkFee

Pet#$,$ HandlerID, WalkCode $-->$ WalkDate

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

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

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

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

$---------------------$

NOTE: This submission is necessary in order to facilitate self practice of the concepts as we build towards a full database plan. Your Professor will track the submissions and randomly verify the solutions provided. Submit your answers by clicking on the above title, before moving on to Class $3$ Module.