Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.ms-sqlserver > #1858 > unrolled thread

E-R diagram

Started by"Tony Johansson" <johansson.andersson@telia.com>
First post2015-01-23 17:45 +0100
Last post2015-01-23 11:16 -0800
Articles 2 — 2 participants

Back to article view | Back to comp.databases.ms-sqlserver


Contents

  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

#1858 — E-R diagram

From"Tony Johansson" <johansson.andersson@telia.com>
Date2015-01-23 17:45 +0100
SubjectE-R diagram
Message-ID<m9ttqm$gkk$1@dont-email.me>
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

[toc] | [next] | [standalone]


#1859

FromRoss Presser <rpresser@gmail.com>
Date2015-01-23 11:16 -0800
Message-ID<dc771ef1-d3c4-4628-9a59-2914dc87f1d7@googlegroups.com>
In reply to#1858
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.

[toc] | [prev] | [standalone]


Back to top | Article view | comp.databases.ms-sqlserver


csiph-web