PET Medical Store Normalisation

We are going to take a quick look on how to normalize a PET Medical Store.

So our UNF comprises of following entities with values:

PET ID	PET NAME	PET TYPE	PET AGE	OWNER	VISIT DATE	PROCEDURE
1	Nia	Dog	3	Sam	11/11/2014	Vaccination
2	Roy	Cat	5	Neo	23/03/2000	Annual Checkup

Let's see how we can transform the model with our 1NF

Remember the goal is to  reduce redundancy yet have a quality business relation

Since, PET information and the day he visited information can made independent, our 1NF with PET ID and Visit ID as primary key will look like:

 Ummm...does it look perfect to you?
Is there any redundant information there? How about we form a seperate entity for procedure, since it's good to keep a track of which procedures are available for treatment. We can also perform lot's of analytics on it... But that's for future purpose.
Our 2NF is:

 Here we have our final 3 entities with primary key as PET ID, Visit ID & Procedure ID for 3 seperate entities.
You may have a question as to why Owner didn't get a separate entity for himself, well our primary target here was Pet. And the business decision here was we will identify our customers by Pet and not Hooomanns.

Link for the scribbled ppt can be found here: https://docs.google.com/presentation/d/11a-xLAiQc-8sjeqYqb29YJL7j8KSeq5B8FkgOCTPxoU/edit#slide=id.g1f9d30deca_0_319

Thanks for reading!!
Cheers!!