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,150 of 19,505   
   Tony Johansson to All   
   About E-R model for horsejumping   
   01 Feb 15 13:33:55   
   
   From: johansson.andersson@telia.com   
      
   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   
      
   --- 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