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.

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