Current operational system to embrace the opportunities

Assignment Help Database Management System
Reference no: EM132142111

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.

Verified Expert

In this assignment we have studied database concepts. Here we studied database design and studied the different concept of database and we have also studied test cases and analysis of overall assignment and outcome is we have got database design and solve queries for large and small database application

Reference no: EM132142111

Questions Cloud

Define what makes a government strong : Evaluate whether new nations depend of strong governments to succeed. Take a position on whether strong governments are necessary to ensure stability.
What is the compound annual rate : You can borrow $500 today and repay $550 in two weeks. What is the compound annual rate implied by this 10 percent rate charged for only two weeks
What would be the theoretical maximum clock rate : Suppose that in n a particular implementation of the MIPS single-cycle design,the lw instruction takes the longest amount of physical time to execute at 3.5 ns.
Determine how the state will vote : The existence of the Electoral College is one indicator that the United States is not a true democracy in terms of representation.
Current operational system to embrace the opportunities : the Client has outlined a need to improve their current operational system to embrace the opportunities provided by contemporary information technology
Has kelvin committed an ethical lapse : Kelvin planned to provide his friend with internal design specifications and the assessment criteria to be used for vendor selection for the initiative.
Best ways to give and receive critical feedback : List what you consider are the best ways to give and receive critical feedback.
What is the expenditures approach to measuring gdp : What is the expenditures approach to measuring GDP? Give the equation and tell me what each symbol stands for. Give an example and a determinant for each.
What role did commercial banks played : Explain why the accumulation of external debt is a common phenomenon for developing countries and spiraled in the 1980s. What role did commercial banks played?

Reviews

urv2142111

11/29/2018 1:13:05 AM

Thanks the solution you have provided is very good , I sent my wishes to the expert when I received the solution from your team but now I have received the gradings as well. I am very much impressed with the work. This is worth buying the assignment, Thanks once more.

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd