Assignment Definition:
You have been asked to develop a database to maintain details of the football teams signed up to play in a local league, including the schedule. The database must maintain details of the name and location of each team, and for each team the players (and their positions) who are on the team. So that a handicap system can be developed later the database should maintain the gender, and age of each player. Each player should also have one 'phone number stored. Schedule and field locations for each of the games the teams will play. This data model will be reviewed and taken from the conceptual model to logical model status.
Make sure you define the following:
1. Select database management system (Oracle, SQL Server, MYSQL, etc) and identify the data types and sizes for all attributes.
2. Make sure all relationships have been addressed and corrected.
3. Review data model to make sure data model is in at least 3rd normal form (as defined by the normalization process).