Hey guys I was hoping I could get some help with the design of this database. If need be, I'll try to explain it best I can of what it's supposed to do, I think I have most of it set up right, I just think something is wrong with this one table and I can't figure it out.
My db is for the college I go to. It's basically to keep track of track and field stats for the track coaches. It will also be put into a MySQL db, the only reason I have it in access right now is to make sure all of the relationships work and it makes an alright ERD.
the pic attached is what the relationships look like but something is off with that 1:1 relationship and I can't pinpoit it. Btw, I'm not the greatest DB guy out there so.
ATHLETE AthleteID (text 15) AthleteFirstName (text 15) AthleteLastName (text 25) AthleteDOB (date) AthleteHome (text 25) AthleteHighschool (text 40) AthleteYear (text 2) AthleteGender (text 1) AthleteWeight (number 3) AthleteHeight (number 3) AthleteEvents (text 15)
ATHLETE_PARTICIPATION MeetingID (number) AthleteID (text 15) TEventID (text 20) EventMark (number)
MEETING MeetingID (Autonumber) EventName (text 15) EventLocation (text 20) EventDate (date) EventSeason (text 10)
EVENTS EventID (text 20) EventName (text 15)
UNNAMED_INTERMEDIATE_TABLE EventID (text 20) MeetingID (Number)
I put it in iCode so its easier to read, hope that's ok