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

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 ...

Question 1 unified communications system eg email

Question: 1. Unified Communications System (e.g., email, conferencing, and messaging) - The local area network is slower than needed, especially for newer, cloud-based applications. The email system needs refurbishment a ...

Sql assignmentin these exercises youll enter and run your

SQL Assignment In these exercises, you'll enter and run your own SELECT statements. You will use the MyGuitarShop database for these queries. If you do not already have the MyGuitarShop database, the SQL script and the i ...

The system development team at the xyz company is working

The system development team at the XYZ Company is working on developing a new customer order entry system. In the process of designing the new system, the team has identified the following data entity attributes: Invento ...

Suppose that we have a table of house prices and a table of

Suppose that we have a table of house prices and a table of zip codes: • hprices(hid (PK),address,bedrooms,price,zipcode) • zipcodes(zipcode (PK),state) Write a SQL query that finds the average, maximum, and minimum pric ...

Question team project submission - submit to the unit 4

Question: Team Project Submission - Submit to the Unit 4 Group Project Area This version of the capstone project assignment is FOR GRADING this week. Submit to the group area the document containing completed Sections On ...

Sql transactions exercisesconsider table itemnameprice

SQL Transactions Exercises Consider table Item(name,price) where name is a key, and the following two concurrent transactions. T1: Begin Transaction; Update Item Set price = 2*price Where name = 'pencil'; Insert Into Ite ...

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.

Question create an erd for the following scenario once you

Question: Create an ERD for the following scenario. Once you submit you will get access to the correct way to create the ERD. Please watch the video and correct any errors in your submission and resubmit. A small company ...

In sql developercreate a table userpermissions provide

IN SQL DEVELOPER Create a table UserPermissions (provide create and insert statements code) Document UserName Policy SYSTEM Menu JDOW W2 USAM Permissions SYSTEM W2 JDOW Form 1040 USAM Policy JDOW W2 SYSTEM Write a PL/SQL ...

  • 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