Mysql roster question

Im working on a roster for a sports league. Each team has thier own roster and should be able to add to it in theory. I was wondering if any 1 had any ideas on how to set up the team database. should i make a row for each position in the team (e.g. pitcher, catcher, 1b, 2b etc…)

Also i was wondering if it is possible to have php create a page depending on the information in the database. (e.g. team one would have there own page created from information in database that will show scheduel, roster, profile, standings)

any ideas?
Thanks