X-Received: by 10.236.3.106 with SMTP id 70mr6548943yhg.20.1422040568108; Fri, 23 Jan 2015 11:16:08 -0800 (PST) X-Received: by 10.140.102.234 with SMTP id w97mr24896qge.37.1422040568048; Fri, 23 Jan 2015 11:16:08 -0800 (PST) Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!v8no3067866qal.1!news-out.google.com!q4ni0qan.0!nntp.google.com!bm13no2550115qab.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.ms-sqlserver Date: Fri, 23 Jan 2015 11:16:07 -0800 (PST) In-Reply-To: Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=173.61.135.70; posting-account=SOVadwoAAAB3h7W1MLW9kMYtEc2JW2L8 NNTP-Posting-Host: 173.61.135.70 References: User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: Subject: Re: E-R diagram From: Ross Presser Injection-Date: Fri, 23 Jan 2015 19:16:08 +0000 Content-Type: text/plain; charset=ISO-8859-1 Xref: csiph.com comp.databases.ms-sqlserver:1859 On Friday, January 23, 2015 at 11:45:46 AM UTC-5, Tony Johansson wrote: > I'm working on a E-R diagram over horsejumping and would like a comment on > one thing > I have several entities and one of these is Riders. Is it sensible to add > another attribute to the Rider entity to store the result for this rider > in the competition. > > //Tony If your database is storing only one competition, yes. If you are storing multiple competitions, then you need a Competitions entity and a Competitions/Riders join.