Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
brubaker
Starting Member
15 Posts |
 Posted - 2005-03-25 : 15:50:46
|
| Hello all,I'm trying to design my database for a youth baseball league. Everything is fairly straight forward, except for one problem. I'm not sure how to account for siblings. This is important because siblings that are close in age must be placed on the same team and additionally, families with more than one child are entitled to discounts.Conceptually, the database looks like this:Table 1: Players. Holds all of the players personal information (ID, name, address, parents, etc.)Table 2: Registrations. Holds information about yearly registration of each player (ID, foreign key to Table 1, amount paid, method of payment etc.) I did it this way because while the players remain the same from year to year, they must pay each year.I was thinking of having a 3rd table that records relationships between two players (ID, foreign key to table 1 for first brother, foreign key to table 1 for second sibling). The problem with this is that it only records the relationships of two players, but some families have up to five kids.One solution was to record the relationship to the oldest child, but when that kid leaves the league all the relationships would break.I could give you the exact table structure for each table, but I'm not sure that would help. Just think of a baseball league where some players have relatives in the league (i.e. brothers or sisters), but most do not.Any help is greatly appreciated. |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-03-25 : 15:53:17
|
| create a table of families. one row per family.In that table store parent information, address, etc.Then just assign each player to a family. All players in the same family are siblings, and now your data is better normalized since you aren't repeating infomation about the family over and over for each player.- Jeff |
 |
|
|
|
|
|
|
|
Accounting for Siblings in Sports League