Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


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

Re: 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 Erland Sommarskog <esquel@sommarskog.se>
Newsgroups comp.databases.ms-sqlserver
Subject Re: About database design
Date Sun, 25 Jan 2015 18:18:42 +0100
Organization Erland Sommarskog
Lines 16
Message-ID <XnsA42DBA47632Yazorman@127.0.0.1> (permalink)
References <ma2uli$jr1$1@dont-email.me>
Mime-Version 1.0
Content-Type text/plain; charset=windows-1252
Content-Transfer-Encoding 8bit
Injection-Info mx02.eternal-september.org; posting-host="416ef8a880b1e4f6f96e9a7c39a8d7a9"; logging-data="1390"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+OW6JUD7CncWcul6Jz4s5O"
User-Agent Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock sha1:kxEktR4ENr4Ul1bsEPmuRCkELRg=
Xref csiph.com comp.databases.ms-sqlserver:1861

Show key headers only | View raw


Tony Johansson (johansson.andersson@telia.com) writes:
> 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?
> 

Yes, sounds like a CompetitionMembers table with CompetitionID and RiderID 
as the primary key.


-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

Back to comp.databases.ms-sqlserver | Previous | NextPrevious in thread | 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