home

Welcome.

The following text is the assignment outline, for reference. __**Task Requirements and their responses can be found on the pages labelled ''Task 1", "Task 2' and so on.**__

You have been appointed to new manger of your local AFL football club. They currently have a manual non-computerised management system, which is becoming extremely hard to keep track of data and paper work.
 * Scenario:**

You are to create a database to help keep track of teams and team members.

The manual system works in the following way:

A new player fills out their details on a registration form. If one family has more than one child playing, more than one registration form must be filled out. Information such as: name, address, phone number, date of birth and team is filled out on the registration form. The manager must then collate this information and type up all necessary information for the coaches (the team they are coaching and individual player’s information) which can be either printed or emailed to each individual coach. It would be beneficial for the AFL club to have a:
 * Full team report – All players’ information shown, so the manger can see all the players information in the report. This makes it easier to see where new players may fit in, when you look at age division.
 * Team contact report – A report that can be printed or emailed to the coach with players name, address and telephone number, if they need to be contacted.
 * Training clashing report – This would ask for the insertion of the training night of a team in a form, to see which teams are training on the scheduled nights.

Many of the AFL club managers and members are sceptical on using new technology to track this type of information. You must make the user interface simple and easy to use, by using menus where information can be added and/or edited for teams and team members or reports can be viewed and printed. The database must be submitted in a captive environment to avoid other users from altering the database in any way.