id int(10) auto_increment primary key
I have these questions:
1 - Should team be an integer linking it to a team table or just put the team name within it.
2 - The same question as number one, but pertains to mascot table.
3 - Conference would most likely be something similiar "East", "Central", etc. Would it just be best to put that in it, or make a table and put the descriptions in, linking them with a foreign key
4 - Same as the above, but would hold information akin to "AAAAA" or "AA", etc..
Which would be faster and more friendly when trying to extract data/compare things?
The thing is that each team would have to have conference and classification put together too, like: AAAA East, AA Southwest Things of that nature
id, team_id, year, school, mascot, sport, state, conference, classification