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

    receives the data it opens the frame and reads the data and then send of the receipt of acknowledgement to the computer then transmitted the data and the token is destroyed and a new free token is created. Network Topologies Network topologies are the way that nodes on a network are arranged.

  2. Peer reviewed

    Networking Diagrams and Case Study

    3 star(s)

    Now that all of the LAN networks have been set-up, it would just be a matter of creating the VPN and interconnecting the head-office and all of the stores. 7. Test the VPN to ensure that everything is working, and once this is finished.

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

    The location is also considered for the US compensation package. To start the compensation review, first Mastek has to map the US Grades with the Indian Grades. The US Grades are as follows: - D2 D1 C2 C1 B2 B1 A2 A1 How they are mapped: - Indian Grade US

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

    Data can be transferred to and from a hard disk much more quickly than from a floppy disk. Your hard disk will be where you store: * the operating system * programs * the majority of your data files Backing store - optical disks CD-ROM (Compact Disk Read Only Memory)

  1. ICT Sample Work Welcome Centre Requirements

    They have only just installed a network, which has been set-up complete with user accounts and passwords, shared folders, as well as private folders for individual users. The Welcome Centre should save the solution onto the network, as this will certainly meet the requirement of being able to keep the solution secure.

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

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

    because it doesn't tell you all the information about the potential user. It doesn't include things like the telephone number in case the company needs to get in touch with the user of the system. Structure 2 This database design structure is slightly better because it gives you a bit more information about the potential user.

  2. Computer Aided Design Package

    If the company buys the computers or build them up they are going to need to have an operating system to integrate the hardware and software together. The operating system will communicate directly with the BIOS of the motherboard to find out what components are plugged into the computer and what types they are.

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