Database Assignments: Major Leaguer Baseball

 

Database Objects

 

Players:

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.

Teams:

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.

Team/Players Junction:

Create a junction table in which you can enter a team and then its corresponding players.
Team and Players: Create a form and a report that each displays limited information about a team (such as Name, Web Site, and Manager) and a list of its players.