Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1870 > unrolled thread
| Started by | "Tony Johansson" <johansson.andersson@telia.com> |
|---|---|
| First post | 2015-02-01 13:33 +0100 |
| Last post | 2015-02-02 09:12 -0800 |
| Articles | 2 — 2 participants |
Back to article view | Back to comp.databases.ms-sqlserver
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
| From | "Tony Johansson" <johansson.andersson@telia.com> |
|---|---|
| Date | 2015-02-01 13:33 +0100 |
| Subject | About E-R model for horsejumping |
| Message-ID | <mal6f2$ajg$1@dont-email.me> |
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
[toc] | [next] | [standalone]
| From | Ross Presser <rpresser@gmail.com> |
|---|---|
| Date | 2015-02-02 09:12 -0800 |
| Message-ID | <5019f0d4-6b8e-46df-9bd5-743298d4f9cb@googlegroups.com> |
| In reply to | #1870 |
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.
[toc] | [prev] | [standalone]
Back to top | Article view | comp.databases.ms-sqlserver
csiph-web