Code:
Model To record results of competitors at events
Entities Competitors
Tracks
Trainers
Events
Relationships Trainer can have many competitors
Tracks can have many events
On the same day a competitor can not be in more than one event
Events can have many competitors
Tracks can have many trainers and competitors
Code:
Table Competitors Tracks Trainers Events
CompName_ID TrackName_ID Trainer_ID Event_ID
Name State First Name Date
Mother City Last Name Time
Father TrackName Location
Age Location Category Event Number
Height Distances(Starts) Competitor Number (Per Event)
Distances(Sectionals) Times(Race Total)
Track Condition Times(Sectionals)
Times (Race Per Competitor)
Times (Sectionals Per Competitor)
Competitor Weight
There were a further two categories I couldn't fit in as they were more descriptive and not specific to any particular table.
Location (Home Track) Competitor
Location (Home Track) Trainer
My other concern is that whilst some distances are unique to some tracks most are not. I didn't want to continually replicate distances but wasn't sure if distance was its own entity either.
Edit: This may be better, Or not. I have used FK to mean foreign key.
Code:
Table Competitors Tracks Trainers Events Distances Distance Sectionals Times
CompName_ID TrackName_ID Trainer_ID Event_ID Distance_ID Sectional_ID Times_ID
Name State First Name Date Distance_Starts Dist_Sectionals TimesSectional
Mother City Last Name Time Track_FK Dist_Starts_FK Sectional_FK
Father TrackName Location
Age Location Category Event Number
Height Distances(Starts) Competitor Number (Per Event)
Trainer_FK Distances(Sectionals) Competitor Weight
Track Condition Trainer_FK
Competitor_FK
Track_FK