Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 19,153 of 19,505    |
|    Ross Presser to Tony Johansson    |
|    Re: About E-R model for horsejumping    |
|    02 Feb 15 09:12:30    |
      From: rpresser@gmail.com              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.              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca