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

Re: About database design

X-Received	by 10.52.246.135 with SMTP id xw7mr17803949vdc.8.1422290027148; Mon, 26 Jan 2015 08:33:47 -0800 (PST)
X-Received	by 10.140.95.67 with SMTP id h61mr164375qge.9.1422290027087; Mon, 26 Jan 2015 08:33:47 -0800 (PST)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!peer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!bm13no3133879qab.0!news-out.google.com!q4ni4qan.0!nntp.google.com!v8no3651827qal.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Mon, 26 Jan 2015 08:33:46 -0800 (PST)
In-Reply-To	<ea1f56c5-d603-4d4d-b2ff-73b94413ab98@googlegroups.com>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=194.83.173.135; posting-account=dELd-gkAAABehNzDMBP4sfQElk2tFztP
NNTP-Posting-Host	194.83.173.135
References	<ma2uli$jr1$1@dont-email.me> <ea1f56c5-d603-4d4d-b2ff-73b94413ab98@googlegroups.com>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<1a03d515-3f4a-4d74-96a5-6187ed41e180@googlegroups.com> (permalink)
Subject	Re: About database design
From	rja.carnegie@gmail.com
Injection-Date	Mon, 26 Jan 2015 16:33:47 +0000
Content-Type	text/plain; charset=ISO-8859-1
X-Received-Bytes	1823
X-Received-Body-CRC	4275982501
Xref	csiph.com comp.databases.ms-sqlserver:1863

Show key headers only | 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