Football Database Access Project

[fsagwe]

Dear Members,
Please assist me with coming up with a full working Access football system.Involving tables,queries,forms and reports or involving tables,forms and modules.

[FONT=&quot]KANDANDA FOOTBAL LEAGUE MANAGEMENT INFORMATION SYSTEM[/FONT][FONT=&quot][/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Kandanda football league (KFL) is a secondary organization charged with managing or the inter-school football competition in a county. There are a total of 14 schools which have enrolled their teams and new schools are required to register in order to present their teams. Registration fee for each team is Ksh.50,000 per year. Each school can only register one team.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]A team presented comprises of 18 student players and a coach who is a teacher in the school where the team belongs. AT the beginning of every football game season, each team is required to furnish KFL management with the team’s details.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]All football matches between schools in the county are scheduled for term one of every year. The game is played in the league basis, where each team is paired with every other team. Each pair of teams play two matches; home and away (one match in each of the schools in the pair). The season’s fixtures are determined before the beginning of the season.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Referees who will be officiating the matches are teachers from the participating schools. Schools presenting referees are required to provide their details to KFL. Refe[/FONT]
[FONT=&quot]rees are prohibited from officiating matches involving their schools.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]In a match, the goal scored by each team and the goal scorers are recorded. A win in a game earns a team three points, a draw, one point, and a lose, zero. A player who violates a football rule during a match earns a penalty card. The penalty card earned is recorded against the player. A team whose opponent fails to honor a fixture is awarded a win of 2 points while the opponent does not earn any point. After every game, a league table is updated based on the result of the match. [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]At the end of the season, 30% of the amount collected as registration fee is awarded to the best 3 teams in the ratio 3:2:1 respectively. The best team carries the count’s trophy for the season. [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]The team that earns the lowest number of penalty cards by the end of the season is considered most disciplined. The three most disciplined teams are each awarded a certificate. A team that fails to honor a fixture during the season is not eligible for this award. The three least disciplined teams are reprimanded.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Develop a well-documented system that will:[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]a) [/FONT][FONT=&quot]Register the:[/FONT]
[FONT=&quot] i. [/FONT][FONT=&quot]Schools;[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot] ii. [/FONT][FONT=&quot]Referees;[/FONT]
[FONT=&quot] iii. [/FONT][FONT=&quot]Coaches;[/FONT]
[FONT=&quot] iv. [/FONT][FONT=&quot]Players in each team;[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]b) [/FONT][FONT=&quot]Keep a record of payment by each school.[/FONT]
[FONT=&quot]c) [/FONT][FONT=&quot]Keeps a schedule of fixtures for matches involving schools including their officiating referees.[/FONT]
[FONT=&quot]d) [/FONT][FONT=&quot]Capture a list of match results for every team over the season.[/FONT]
[FONT=&quot]e) [/FONT][FONT=&quot]Generate a league table in order of merit.[/FONT]
[FONT=&quot]f) [/FONT][FONT=&quot]Display a list of the;[/FONT]
[FONT=&quot] i)Players in each team.[/FONT]
[FONT=&quot] ii)Coaches.[/FONT]
[FONT=&quot] iii)Schools and the amount of money collected from each.[/FONT]
[FONT=&quot] iv)Top ten scorers in descending order of scores.[/FONT]
[FONT=&quot] v)Teams qualifying for the awards and the amount that each gets.[/FONT]
[FONT=&quot] vi)Teams qualifying for certificates.[/FONT]
[FONT=&quot] vii)Teams reprimanded. [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot] [/FONT]

 

[plog]

We generally don't 'assist' people by doing everything for them. Especially when their issue is obviously a homework assignment.

If you need specific help for a specific issue, feel free to post a specific question and we will be glad to help, homework or not.

 

[GinaWhipp]

Hmm, looks like you have some work to do and while I agree with plog I'll give you this much. Here's some Data Models to get you started...

http://www.databaseanswers.org/data_models/index.htm

Find one that works or is the closest to what you need and go from there, as step one to a successful database is building a Data Model.