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 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: References: 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 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