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

About E-R model for horsejumping

From	"Tony Johansson" <johansson.andersson@telia.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	About E-R model for horsejumping
Date	2015-02-01 13:33 +0100
Organization	A noiseless patient Spider
Message-ID	<mal6f2$ajg$1@dont-email.me> (permalink)

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Next 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