• 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)

    When two devices are transmitting at the same time results in collision on the network. When data is transmitted between two devices on the network it will also be broadcasted to other devices on the network virtually simultaneously. Advantages * Easy to implement and extend, because it consist of a long cable running through the network.

  2. Peer reviewed

    Networking Diagrams and Case Study

    3 star(s)

    Set up all of the workstations/other required devices in both the store and Head Office. 4. Connect all of the devices in each premises to the router, and each router to the modem (Setting up the LAN). 5. Once both LAN networks have been established, ensure that both are also connected to the internet.

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

    disks are optical disks that use the same technology as musical compact disks. They store up to 650 Mb of data and a laser beam is used to read the data off the disk. Data is written onto the CD-ROM disk before it is sold and cannot be changed by the user.

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

    Integration The Payroll component is integrated with other SAP HR components, such as Personnel Administration and Benefits. There are also interfaces to other SAP modules such as Financial Accounting and Controlling. 2.1 COMPENSATION FOR USA PAY SCALE TYPE During the discussions it was realized that across Mastek Group, the compensation

  1. Different ways of data capture

    Hacker * As traffic increases on the network the performance degrades unless it is properly designed. Requirements of A Network Any sort of networks require maintenance - someone has to be responsible for ensuring that * Response time is adequate * Hardware is upgraded when necessary * The required software

  2. ICT Sample Work Welcome Centre Requirements

    Enterprises Ltd." The following fields must be shown on the Quotation: ADDRESS BLOCK: Title, First Name, Surname, Company Name, Address Line 1, Address Line 2, Town, County, Postcode EVENT DETAILS: Quotation No., Quotation Date, Event Name, Event Date, Start Time, End Time, No.

  1. Smart Card System

    This means that the source and destination IP address remains constant as the packet traverses a network. Each time a packet travels through a router, the router will reference it's routing table to see if it can match the network number of the destination IP address with an entry in its routing table.

  2. System I designed in order to produce a promotion package for her newly formed ...

    CD Sample This is a bad database. It has only four fields and does not tell you any details of the potential user or how many CD's are in stock. The data is placed in any order so it is difficult for the user to find the Title of the CD or CD's they want to order.

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