Dealing with sports events, 2 issues I have questions with, venue name changes and on a similar vein, competitor name changes. Female golfers (Dottie Pepper and Dottie Mochrie for example) played events in different years under different names. I want to be able to list the event and refer to the golfer but not have to list as 2 people, or sports venues that may change names but remain the same facility. What is he best way to set this sort of thing up?
Adam Schwanz 4 months ago
I would probably make an Alias table and link it to them.Customer Dottie Pepper and then link her CustomerID to an Alias Dottie Mochrie. Assuming they have multiple names, if it's a name CHANGE permanently (marriage or something) I would probably just change the name in the customer table and move on, if you really had to store that old information I'd store it in a seperate field.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.