• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36

Creating a computer system for Wooten Basset Rugby Club

Extracts from this document...

Introduction

1 Analysis 1.1 Introduction Wooten Basset Rugby Club, are a rugby club in the Swindon area, whom play 15 a side rugby union. They put out a numbers of teams each week ranging from junior levels, senior teams and women's rugby. Of my concern is the U-16s, whom would like to computerise a number of tasks and have a reference for relevant data including player and parent information. In any particular season there will be between 20 and 30 players at the club. These players are trained by the head coach and around three other coaches all of whom are made up of parents of the players. The head coach is responsible for much of the current administrative work. 1.2 Current System Currently all tasks for the club are carried out manually. For example when organising a match against a rival team a letter is written specifically for each player. With as many as 30 players at the club, this is tiring and tedious work. Data is currently stored in files kept at the head coach's house. This system of holding information has become unreliable as over the history of the team players have moved on or changed their details. When this occurs due to time constraints, addresses for example are often added to rather than modified creating two distinct addresses complicating matters when important letters need to be sent. In the past when players have left their file has not been removed leaving large amounts of useless information. All of this complicates matters when searching for data making the process longer and increasingly unreliable. Among the squad of players, each player has his own specific needs. For example different players require different training methods such as fitness or tactics. With many players and few coaching staff it becomes difficult to organise. Currently this is organised through memory which is difficult due to the above reasons. ...read more.

Middle

1. Leading Drop Kick Scorers, Leading Penalty Kickers, Leading Try Scorers and Leading Points Scorers Each of these reports will present in order the leaders for each respective statistic. For example the Leading Drop Kicks reports will be grouped Player's name but will also hold data on the player's membership number and the number of drop kicks scored. The leading drop kicker comes first and the report will be in descending order downwards. This will be similar for the Leading Penalty Kickers and Leading Try Scorers reports. The Leading Points Scorer report will not only show membership number, name and the descending order of leading points scorers but also display the amount of drop kicks, tries, and penalties scored by that player. The source of this data will be the queries, qryTotalPoints, qryTotalDropKicks, qryTotalPenalties and qryTotalTries. 2. Disciplinary Record The Disciplinary report will present information form qryDisciplinary. It will be grouped by the player's name and display each player's disciplinary record for that season up until that point. This means each yellow or red card received and the match they receive it in will be shown. 3. Season Overview The Season Overview report will be based on the query, qrySeason. It will display all the matches of that season and their scores in chronological order. 2.6 Letter Design Vital to the user's requirements for the system was the facility to create standardised letters. There are three letters the system will provide, one that informs players of outstanding fees and another that informs players of fixture information. The outstanding fees letter will be based on the query, qryFees. The letter relating to fixture information will be based on the qryOrganiserAway and qryOrganiserHome queries. 2.7 Menu Design In order to comply with user requirements the system must be as simple and user friendly as possible. Therefore the menu must be kept simple to avoid confusion. The system will open in a main menu offering the user three options: Add/Delete Data, Reports and Letters. ...read more.

Conclusion

The Add/Delete button has a macro called mcrCloseRivals that closes the form, frmRivals and opens the form, frmAdd/Delete. There is a combo box allowing the user to choose a team name and navigate records this way. frmfixtures This form has a combo box where by choosing a FixtureCode navigates through the records. The Add/Delete Data Button is controlled by the macro, mcrCloseFixtures which closes frmFixtures and opens frmAdd/Delete. The Add Fixture button loads a blank record and the Delete Fixture button deletes the current record. frmTournament This form has a drop down menu where a TournamentCode can be chosen. The Delete Tournament button deletes the current record and the Add Tournament loads a blank record. a macro applied The Add/Delete Button has mcrCloseStats which closes the form, frmStatistic and opens the form, frmAdd/Delete. frmStatistics This form has a sub form called frmPlayers-Fixtures which lists all the records matching a given FixtureCode. To view the record the combo box View Fixture allows the user to choose a precise fixture. The Add/Delete Button has a macro applied mcrCloseStats which closes the form, frmStatistic and opens the form, frmAdd/Delete. 6.2 Queries Queries are all described in the 2.4 Design section. 6.3 Macros Macros described under 6.1Forms. 6.4 Reports Reports are described under the 2.5 Report Design. Rugby Club System 1 Analysis 1 1.1 Introduction 1 1.2 Current System 1 1.3 Interview Summary 2 1.4 Data Requirements 2 1.5 Entity Relationship Diagram 2 1.6 Data Flow Diagrams 2 2 Design 2 2.1 System Design 2 2.2 Attribute Design 2 2.3 Form Design 2 2.4 Query Design 2 2.5 Report Design 2 2.6 Letter Design 2 2.7 Menu Design 2 2.8 Macro Design 2 3 Testing 2 3.1 Testing Strategy 2 Test No. 2 Test 2 Expected Result 2 3.2 Test results 2 4 Appraisal 2 5 User Manual 2 5.1 Adding and Deleting Data 2 5.2 Reports 2 5.2 Letters 2 6 System Maintenance 2 6.1 Forms 2 6.3 Macros 2 6.4 Reports 2 1 Gareth Moore - 4524 New College - 66528 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Computer Science essays

  1. Marked by a teacher

    LAN & Topologies & Data Flow

    3 star(s)

    * Centralization can be a drawback if it there is high utilizing of the network because it will result in performance drop in the traffic on the network. Mesh Topology - In this type of topology each of the nodes are connected with each other.

  2. Peer reviewed

    HCI shortened for Human Computer Interaction is the study of the human and computer ...

    3 star(s)

    an extent of it becoming addictive to them, that if they do not go on it they are not happy. It has affected people's behaviour and even their social life. It has also impacted families has it has brought families together to spend quality times together.

  1. Identify the constituent parts of a total computer system.

    Main store consists of a large number of electronic circuits and all data and information that is processed by the computer has to go through main store. When a sequence of instructions (program) is being executed by the computer system the control unit ensures that the data that is used

  2. Stace & Dunphy (2001) identify five dilemmas of change

    support for women as opposed to marital support; both arrangements tend to reinforce patriarchy. In this regard, the rise in poverty among women is an important structural level variable to consider, but the lack of reliable data going back to 1947 makes testing difficult.

  1. System Analysis The aim of the Jewellery store system is to make the work ...

    Data flow models (DFM) A data-flow diagram (DFD) is a graphical representation of the "flow" of data through an information system. DFDs can also be used for the visualization of data processing (structured design). On a DFD, data items flow from an external data source or an internal data store to an internal data store or an external data sink, via an internal process.

  2. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    Further reports can be generated using Ad Hoc Query in conjunction with an SAP Payroll Infotype. However bulk of MSI requirements for legal reporting etc shall be met by ADP as the net payroll processing will be in their domain.

  1. I have been given the task of creating a system for a hospital to ...

    * A computerised system can find files within seconds where as on a card filing system it would take people a lot longer as it has to all be done by people and then the process is subject to human error.

  2. Ilford Cricket Team Data Analysis Project.

    The only problem might be the level if computer literacy that the cricket team has, but because of the simplicity of the system, the team will be able to operate the system with very little training. Therefore very soon the team will be able to operate the systems efficiently and so this means that the system is operationally feasible.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work