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

About database design

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail
From	"Tony Johansson" <johansson.andersson@telia.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	About database design
Date	Sun, 25 Jan 2015 15:30:26 +0100
Organization	A noiseless patient Spider
Lines	10
Message-ID	<ma2uli$jr1$1@dont-email.me> (permalink)
Mime-Version	1.0
Content-Type	text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding	8bit
Injection-Date	Sun, 25 Jan 2015 14:30:10 +0000 (UTC)
Injection-Info	mx02.eternal-september.org; posting-host="8fdc2b5af81c338deb7045fc6c39b0e2"; logging-data="20321"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18sZcX1UDLyfffyxhij1PPE"
X-MimeOLE	Produced By Microsoft MimeOLE V6.0.6002.18463
X-Newsreader	Microsoft Windows Mail 6.0.6002.18197
Cancel-Lock	sha1:ncP1PRXhQrc+in2NEr/TJG5MC64=
X-Priority	3
X-MSMail-Priority	Normal
Xref	csiph.com comp.databases.ms-sqlserver:1860

Show key headers only | View raw

I just wonder what relation do we have between Competition and a Rider.
We know that a competítion have many riders in horse jumping..

But can a rider paricipate in many horse jumping competition but not at the 
same time.
So do we have a many to many or one to many in the connection between 
Competition and Rider in horse jumping?

//Tony

Back to comp.databases.ms-sqlserver | Previous | Next — Next 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