Groups > comp.databases.ms-sqlserver > #1863

Re: About database design

Newsgroups	comp.databases.ms-sqlserver
Date	2015-01-26 08:33 -0800
References	<ma2uli$jr1$1@dont-email.me> <ea1f56c5-d603-4d4d-b2ff-73b94413ab98@googlegroups.com>
Message-ID	<1a03d515-3f4a-4d74-96a5-6187ed41e180@googlegroups.com> (permalink)
Subject	Re: About database design
From	rja.carnegie@gmail.com

Show all headers | View raw

On Monday, 26 January 2015 15:34:39 UTC, --CELKO--  wrote:
> >> So do we have a many to many or one to many in the connection between  Competition and Rider in horse jumping? <<
> 
> Where is the horse in this model? A rider cannot be
> in two places at once, but neither can a horse.

I am not sure whether the rider or the horse
is considered to be the competitor.  But I think
they go together; if one of them breaks a leg and 
must be shot, the other retires from the contest.

I suppose that a "competition" of this sort may
include several scores; time taken, number of 
fences jumped, grooming, not leaving an additional
hazard on the course for the next competitor...

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

About database design "Tony Johansson" <johansson.andersson@telia.com> - 2015-01-25 15:30 +0100
  Re: About database design Erland Sommarskog <esquel@sommarskog.se> - 2015-01-25 18:18 +0100
  Re: About database design --CELKO-- <jcelko212@earthlink.net> - 2015-01-26 07:34 -0800
    Re: About database design rja.carnegie@gmail.com - 2015-01-26 08:33 -0800

csiph-web