Create a table, a form, and a report, that represent players. Information for each player includes FullName, DateOfBirth, Height, Weight, JerseyNumber, Foot (whether the player is left foot or right foot), PrimaryPosition, SecondaryPosition, Picture, RecentClub, and Bio (Brief). You may find a list of players at http://mlb.mlb.com/NASApp/mlb/mlb/players/index.jsp.
You must have at least one player for every position and a designated hitter.
Create a table, a form, and a report, that represent teams. Information for each team includes OfficialName (example Yankees), AliasName (example The Bronx Bombers), Address (the team's headquarters), TelephoneNumber, FaxNumber, WebSite, EmailAddress, President, Manager, HomeJersey (a picture of the uniform that the team wears when playing at home), AwayJersey (a picture of the uniform the team wears when playing away from home), StadiumAddress, StadiumPicture, Comments.
You must include players from at least three different teams.
Create a junction table in
which you can enter a team and then its corresponding players.