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

Re: E-R diagram

Newsgroups	comp.databases.ms-sqlserver
Date	2015-01-23 11:16 -0800
References	<m9ttqm$gkk$1@dont-email.me>
Message-ID	<dc771ef1-d3c4-4628-9a59-2914dc87f1d7@googlegroups.com> (permalink)
Subject	Re: E-R diagram
From	Ross Presser <rpresser@gmail.com>

Show all headers | 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