This is the list of attributes I was given that each participant will need to have...if you have experience with this or think of something else I need, please let me know.
Each player will have
name, parent name, address, phone#, cell#, email, emergency contact name, emergency number, alternate emergency number, date of birth, race, height, weight, position, shirt size, short size , pant size, school name, school city, grade level, gpa, year graduating, and planning on college (yes/no).
Parents can have multiple kids, one person can be the contact for many kids, and a school is going to have kids. So these are the tables I came up with
Parent - 1 to Many - Players
Emergency Contact - 1 to Many - Players
School - 1 to Many Players
So the Player tables loses the parent data, school data, and emergency contact. They are replaced with a parentID, schoolID, and emergencyID
Would you consider this normalized or can I take it further?
This post has been edited by ill0pcode: 15 June 2010 - 12:34 AM