home bbs files messages ]

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