Chapter 3 Exercise 8

8. Define the tables needed to extend the Pet Store database to handle genealogy records for the animals.

Possible modification: Add MotherID, FatherID to the Animal table, but you should then add a second table for external animals—not necessarily ones for sale.

Animal(AnimalID, Name, Category, Breed, DateBorn, Gender, Registered, Color, Photo, MotherID, FatherID, PetStore)