[Novalug] Database advice

[Jon LaBadie]

On Mon, Mar 15, 2010 at 03:54:29PM -0400, Bonnie Dalzell wrote:
> On Mon, 15 Mar 2010, John Holland wrote:
> 
...
> > Litters could be identified by birthday, without requiring an addtional table 
> > (mom + birthday =  unique litter) , or there could be an additional Litter 
> > table with links from the dogs to that as well. (a dog has a Litter ID 
> > attribute)
> > And probably links from the litter table to the mother & father dogs.
> 
> Actually now that we do DNA parent testing on litters it is possible to 
> have pups with different fathers born on the same day from the same 
> mother.

Might there also be multiple birthdates for the same litter.  Birthing could
certainly begin on one evening and end the next day.

-- 
Jon H. LaBadie                  jon at jgcomp.com
 JG Computing
 12027 Creekbend Drive		(703) 787-0884
 Reston, VA  20194		(703) 787-0922 (fax)