Building a database for my breeding program
I am building a database for my dog breeding program. I created my ERD, but I keep running into snags. I am trying to tract my Customers, dogs, litters and puppies. I also need to include medical records and health testing records for my dogs, puppies and litters. One of my issues is in litters. Each litter has several puppies and each puppy needs their own record, but still needs to be tied to a particular litter. I am looking for any suggestions on a better way to build my ERD. Thanks in advance!