1. Create a database, which fulfills the following requirements:
Structure:
list of countries
list of football players, each player has a name, surname and nationality
(referring to the country above)
list of football clubs, each club has a name, and plays in a national league of
selected country
relations (and optional additional tables), which describe in which club did
the player play during a particular season (in a particular year), and what was
his monthly salary there
Technical requirements:
data has to be stored in XML or MS ACCESS file
the application should use the typed dataset
database should have a third normal form (3NF)
2. Create a test application (ASP.NET or Windows Forms), which manages the
database above
Test application functionality:
Data input:
interface for adding, editing and deleting the countries
interface for adding, editing and deleting the clubs and assigning them to
countries
interface for adding, editing and deleting the players
interface for assigning a player and his monthly salary to a club for a
particular season,
Displaying the data:
for selected player: his career (list of clubs he played in together with
monthly salaries), sorted by seasons and a total amount of money he has
earned during his life from playing football
for selected club and season: team members and total monthly salary
for selected club: all the players who played in the club with the number of
seasons they played there
for selected country and season: a list of clubs in the country and the ratio
of foreign players against all the players in a football league in this country