Back to the Data Model.
The Area being Modelled is :-
Dog Breeeding and Research.
Janet writes :-
Question: I wonder if you could help me, please?
I am a breeder of Border Collie Sheepdogs for the last 25 years and want to coalate
all my information/pedigrees/ health testing etc into a database so that I can start
a research project on the hereditable nature of sheepdog herding traits and behaviour
and also in the better rearing of puppies to hopefully reduce the number of temperament
problems such as nervousness, fear, sound sensitivity etc.
For the above I probably need a database to hold all my Breeding dog records.
Individual dog record - include litter siblings and additional half siblings Sire record -
include litter siblings and additional half siblings Dam record - include litter siblings
and additional half siblings Veterinary health record ? include current and genetic
predisposition Breeding record Temperament record Training record Competition record
Ownership record ? could have two or more owners Breeder record Breeding co-efficient
Estimated breeding values.
And importantly a genealogy relationship to show the six to ten generation pedigree of each dog. Border Collie Puppies.
Barry has identified the 'Things of Interest' as follows :-
4. User Logins
© DataBase Answers Ltd. 2010