1. Identify all the candidate keys of the relation, and then identify all the functional dependencies in the relation.

2. Examine the determinants of the functional dependencies. If any determinant is not a candidate key, the relation is not well formed. In this case: a. Place the columns of the functional dependency in a new relation of their own. b. Make the determinant of the functional dependency the primary key of the new relation. c. Leave a copy of the determinant as a foreign key in the original relation. d. Create a referential integrity constraint between the original relation and the new relation.

3. Repeat step 3 as many times as necessary until every determinant of every relation is a candidate key.

The Veterinary 0ffice List-Version One A B C D E F G 1 petName Pet T PetBreed a PetDOB Owner LastName Owner irstName a OwnerPhone OwnerEma 201-823-5467 Marsh Downs@somewhere com Std. Poodle 27 Feb 12 Downs Marsha 1-Feb-11 James 3 Teddy Cashmier Richard 201-735-9812 Richard James SO ere com 17 Jul 13 Downs 201-823-5467 4 Fido Std. Poodle Marsha Downs@somewhere com 5-May 13 Frier 201-823-6578 5 AJ Dog Collie Mix Frie somewhere 201-735-9812 Cat Unknown 6 Jun-10 James Richard Richard James@somewhere com Woolley Cat 7 Unknown James Richard 201-735-9812 Richard James SO ere. com 11-Dec-09 Trent Buster Dog Border Collie Miles 201-634-7865 Miles Trenta somewhere com 9 Jedah Cat Abyssinian 1 Jul 06 Evans Hilary 210-634-2345 Hilary Evans somewhere com The Veterinary 0ffice List-Version One A B C D E F G 1 petName Pet T PetBreed a PetDOB Owner LastName Owner irstName a OwnerPhone OwnerEma 201-823-5467 Marsh Downs@somewhere com Std. Poodle 27 Feb 12 Downs Marsha 1-Feb-11 James 3 Teddy Cashmier Richard 201-735-9812 Richard James SO ere com 17 Jul 13 Downs 201-823-5467 4 Fido Std. Poodle Marsha Downs@somewhere com 5-May 13 Frier 201-823-6578 5 AJ Dog Collie Mix Frie somewhere 201-735-9812 Cat Unknown 6 Jun-10 James Richard Richard James@somewhere com Woolley Cat 7 Unknown James Richard 201-735-9812 Richard James SO ere. com 11-Dec-09 Trent Buster Dog Border Collie Miles 201-634-7865 Miles Trenta somewhere com 9 Jedah Cat Abyssinian 1 Jul 06 Evans Hilary 210-634-2345 Hilary Evans somewhere com