Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!news.swapon.de!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 E-R model for horsejumping
Date: Sun, 1 Feb 2015 13:33:55 +0100
Organization: A noiseless patient Spider
Lines: 14
Message-ID: <mal6f2$ajg$1@dont-email.me>
Mime-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
Injection-Date: Sun, 1 Feb 2015 12:33:38 +0000 (UTC)
Injection-Info: mx02.eternal-september.org; posting-host="8fdc2b5af81c338deb7045fc6c39b0e2"; logging-data="10864"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX19bbGSbeYCszxNLQ7JMQC3E"
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18463
X-Newsreader: Microsoft Windows Mail 6.0.6002.18197
Cancel-Lock: sha1:lFnCSa/9iP0c+jkO6U7A+gcCKSk=
X-Priority: 3
X-MSMail-Priority: Normal
Xref: csiph.com comp.databases.ms-sqlserver:1870

Assume I have many to many relation between a Rider and Competition so I 
will have a relation table in between that I call Participate.
In the entity Rider I have Social security number, Name, E-mail, Address, 
PhoneNumber, Picture, Description
In entity Competition I have Name, Date, Id
In entity Place I have Address, Phone number, E-mail, Name.
I have one to many between Place and Competition.

Now to my question is it sensible to place attribute like StartTime, Track, 
Result, NumberOfFault in the relation table Participate
that is the relation table in between Rider and Competition.

//Tony