Groups > comp.databases.ms-sqlserver > #1859

Re: E-R diagram

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	<m9ttqm$gkk$1@dont-email.me>
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	<m9ttqm$gkk$1@dont-email.me>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<dc771ef1-d3c4-4628-9a59-2914dc87f1d7@googlegroups.com> (permalink)
Subject	Re: E-R diagram
From	Ross Presser <rpresser@gmail.com>
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

Show key headers only | View raw

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.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

E-R diagram "Tony Johansson" <johansson.andersson@telia.com> - 2015-01-23 17:45 +0100
  Re: E-R diagram Ross Presser <rpresser@gmail.com> - 2015-01-23 11:16 -0800

csiph-web