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

Re: About E-R model for horsejumping

Newsgroups	comp.databases.ms-sqlserver
Date	2015-02-02 09:12 -0800
References	<mal6f2$ajg$1@dont-email.me>
Message-ID	<5019f0d4-6b8e-46df-9bd5-743298d4f9cb@googlegroups.com> (permalink)
Subject	Re: About E-R model for horsejumping
From	Ross Presser <rpresser@gmail.com>

Show all headers | View raw

On Sunday, February 1, 2015 at 7:34:14 AM UTC-5, Tony Johansson wrote:
> 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

If Competition is referring to a single race (an outing of several horses on a particular track at a particular time), then yes.  If it's referring to a day's set of races, then no.

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

Thread

About E-R model for horsejumping "Tony Johansson" <johansson.andersson@telia.com> - 2015-02-01 13:33 +0100
  Re: About E-R model for horsejumping Ross Presser <rpresser@gmail.com> - 2015-02-02 09:12 -0800

csiph-web