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 entit...