id int(10) auto_increment primary key
team_id int(10)
year varchar(4)
team ???
mascot ???
sport int(11)
state int(11)
conference ???
classification ???
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
1,1,2011,1,1,1,4,1,1
or
1,1,2011,Oak Ridge,Timbers,Football,KY,West,AAA