Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1861
| 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 | Next — Previous in thread | Next in thread | Find similar
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