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