Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Football Association of Zambia (FAZ) Super League

The FAZ has recently decided to reorganise their operations to support both existing and possibly expanded league operations in Zambia and part of preparation for the 2014 FIFA World Cup. To facilitate this reorganisation and expansion, the Client has outlined a need to improve their current operational system to embrace the opportunities provided by contemporary information technology.

The software to be developed (henceforth referred to as the "Chipolopolo League System") is to facilitate the operations of the League Manager. The Chipolopolo League System is to be developed in database management system (DBMS).

The system shall:

- Allow an operator to enter and maintain the details of all registered football players
- Allow an operator to maintain details of leagues made up of teams
- Allow to enter the scores of the teams after playing their games
- Store the details of all games so that they can be recalled at a subsequent time.
- Display, at any time, a ladder, listing the teams in decreasing order of points scored for a league specified by the user.
- Allows a user, at any time, to obtain a number of pre-defined reports.
- The system should store all results so that it can be closed down and restarted, without loss of data, between games.

There are two useful classifications of the future user community of the Chipolopolo League System:
- The League Officials, most particularly the League Manager, who will have access to the Chipolopolo League System, where they can add, delete and modify player information, enter results etc.
- The Members of the Public, who may wish to access the system to see scores of previous matches, as well as viewing various result reports (eg, League Tables), but will not be permitted to add, delete or modify system entries.

During the course of the requirements elicitation process you made the assumptions that the teams in a league will not be altered during a season.

The system shall perform the following tasks:
- Player Management.
- Team Management.
- League Competition Management.
- Match Scheduling.
- Game Scoring and Score Management.
- Login Security Management.
- Database Management (including data storage and backup).

The detailed specifications are:
Player Management
The system shall support the following features:
- Add new players.
- Delete existing players.
- Update player information.
- Search for players based on various criteria.
Add New Players
The system shall collect the following information about the various players:
- Name.
- Gender.
- Date of Birth.
- Address.
- Home/Work Telephone Numbers.
- Payment Amount.
- Name of Team (if known).
- Players numbers (system assigned).
- Scores scored in season
- Date joined League.
- Date joined Team
Delete Existing Players

The system shall remove all information as outlined in section 1.1.1 regarding a player, when they relinquish their membership to the league.
Update Player Information

The system shall allow all information as outlined in section 1.1.1 regarding a player to be updated Search for Players

The system, when given full or partial details, shall retrieve individual or multiple player details based upon the following criteria:
- Name.
- Gender.
- Date of Birth.
- Address.
- Home/Work Telephone Numbers.
- Financial status.
- Name of Team.
- Player number.
- Date Joined League.
Team Management

The system shall support the following features:
- Add new teams.
- Delete existing teams.
- Update team information.
- Search for teams based on various criteria.
Notes:

1. The system should ensure that teams have a minimum of 11 players and a maximum of 20 players registered with the League.
Add New Teams
The system shall collect the following information about the various teams:
- Team name.
- Team players entered in the season and reserves.
- Application for league competition level.
- Actual league competition level.
- Contact name.
- Contact address.
- Contact Home/Work telephone numbers.
- Is the contact a team member?

Delete Existing Teams
The system shall remove all information as outlined in section 1.2.1 regarding a team, when they disband.
Updating Team Information
The system shall allow the following information to be modified for the various teams:
- Team name.
- Team members.
- League competition level.
- Contact name.
- Contact address.
- Contact Home/Work telephone numbers.
- Is the contact a team member?
Search of Teams
The system, when given full or partial details, shall retrieve the team/s details based upon the following
criteria:
- Team name.
- Team members (players).
- Application for league competition level.
- Actual league competition level.
- Contact name.
- Contact address.
- Contact Home/Work telephone numbers.
- Is the contact a team member?
League Competition Management
The system shall support the following features:
- Creation of a league.
- Allow the league to be given a name.
- Maintain league ladder.
League Ladder
The system shall at any time produce a league ladder with the following characteristics:
- User to specify which league the ladder is to be produced for.
- List teams in decreasing order by points scored.
- The ladder shall be stored in a form so it may be subsequently printed.
- The ladder shall include the following details:
- League name.
- Date.
- Number indicating the team placing.
- Team name.
- Number of match wins.
- Number of matches lost.
6 | P a g e
- Number of matches drawn.
- Number of goals scored
- Number of goals allowed
- The total number of Points.
Notes:
1. If two or more teams have the identical number of points; then use goal differences to determine the
position on the ladder.
2. If two or more teams have an identical number of points and have same goal difference then the teams
shall be listed alphabetically by name.
Match Scheduling
The system shall support the following features:
- Generate a fixture of matches between teams for the season.
- Accept a start date and schedule matches from this date onwards at weekly intervals.
Notes:
1. Each team is to play each other team in their league twice in a season.
Fixture Generation
The system shall generate a fixture with the following details
- League name.
- Season, ie "FAZ Super League 2011".
- A date column
- A Match A column.
- A Match B column.
Game Scoring and Score Management
The system shall support the following features:
- Provide entering of scores for each player and team after the game is played.
- Provide a display of the score after the game is played.
- Allow correction of the score at any stage during the season.
- Details of all games shall be stored so they can be recalled at a later stage.
- Determine which team wins the match.
- Apportion points at the end of a match, to the competing teams in the following manner:
- Two points to the team winning the match.
- One point to each team in a draw.
- Zero points to the team losing the match.
Note:
1. If two or more teams have the identical number of points; then use goal differences to determine the
position on the ladder.
2. If two or more teams have an identical number of points and have same goal difference then the teams
shall be listed alphabetically by name.
3. The system in its presented version shall accept scores via keyboard input only.
Login Security Management
The system shall support the following features:
- Provide password and login name protection, to enable access to the system.
- Provide the user the ability to change their current password.
Note: Before a password can be changed, the system will need to validate the old password and verify the
entering of the changed password twice before accepting.

Database Management

The system shall support the following features:
- The system shall save all data, such that the computer can be shut down and restarted without loss of data.
- Text files shall be used for the database.

Report Management
The system shall provide the following features:
- Produce various reports.
- Store reports in a form, which can be subsequently printed.

Reporting options
The system shall provide the user with the ability to produce the following reports:
- Details of all teams in a particular league.
- Details of all players in a particular league.
- Players listed in descending order of average points per game.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M93129576
  • Price:- $110

Guranteed 48 Hours Delivery, In Price:- $110

Have any Question?


Related Questions in DBMS

Sqlwrite a select statement that returns three columns from

SQL Write a SELECT statement that returns three columns from the Vendors table: VendorContactFName, VendorContactLName, and VendorName. Sort the result set by last name, then by first name.

Analytic reportpurpose the purpose of this task is to

Analytic Report: Purpose: The purpose of this task is to provide students with practical experience in working in teams to write a Data Analytical report to provide useful insights, pattern and trends in the chosen/given ...

Assignment -scenario setup a mock phase 3 clinical trial

Assignment - Scenario: Setup a Mock Phase 3 Clinical Trial for evaluating the efficacy of a Blood Pressure/Weight Loss/ or Muscle Strength Enhancement supplement. Assume that the testing takes place at a physician's offi ...

Question 1 a- consider that you are asked to design an

Question: 1. (a)- Consider that you are asked to design an entity relationship diagram based on the below scenario: A university consists of a number of departments (id, d_name) and each department offers some courses. A ...

Assignment task -write and run sql statements to complete

Assignment Task - Write and run SQL statements to complete the following tasks Part A - DML 1. Show the details of the products where the product code starts with '22'. 2. Display the vendor details from areacode 615. 3. ...

Question create the physical data model for the logical

Question: Create the physical data model for the logical data model that you submitted in IP3. This should include all of the data definition language SQL. Your submission should include all DDL needed to: Create the tab ...

In sql database questions phase-1 in 100 words what steps

In SQL Database Questions: Phase-1 In 100 words, what steps can one take to avoid losing work? Which command is used to save changes to the database? What is the syntax for this command? Phase-2 In 100 words, explain the ...

Data model development and implementationpurpose of the

Data model development and implementation Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop data models and map Database System into a standard development environment to gain unde ...

Databases assignment - monash library services monlib case

Databases Assignment - Monash Library Services (MonLib) Case Study TASK 1: Data Definition For this task you are required to complete the following: 1.1 - Add to your solutions script, the CREATE TABLE and CONSTRAINT def ...

Relational database exerciseyou have been assigned to a new

Relational Database Exercise: You have been assigned to a new development team. A client is requesting a relational database system to manage their present store with the anticipation of adding more stores in the future. ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As