• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 1800

Documentation of a database for a sports centre.

Extracts from this document...

Introduction

Documentation of database Introduction The report is presented to Anna Thomas ("Get Active" Manager). There are many problems that have been stated in the letter from the sports centre. The first problem is the fact that the sports centre has difficulties managing all of the member's details. As there are a lot of members it is difficult to find the information based on the member quickly. It is also difficult to find groups of members and they need to change and check the age of the members (18 and over is an adult). Another problem is that when a member arrives the sports centre need to find and make the membership valid as they are "on site .The best piece of software to use to solve these problems are databases, in this case Microsoft Access. * Validation aims to make sure that data is sensible, reasonable and allowable. It does not check that it is correct. * A Key Field or Primary Key is a field within a database which enables every record to be uniquely identified. * Verification is used to verify that data has been entered into the computer matches the original source data. It does not check that the data is accurate. One way of verification is typing data into the computer twice. The computer automatically compares the two versions and tells the user if they're not the same. ...read more.

Middle

They will be displayed on a separate table to others with different surnames. However in the "Get Active" sports centre database, a query can be made to search for "date member joined" or "expiry date". This can help transfer the details of those who need to update their expiring membership, by sending letters (mail merge). The field names required: * Title * Forename * Surname * Membership Number * Date of Birth * Membership Type * Email * The search Criteria for these could be: * Gender Search (e.g. "Female" or "Male") * Surnames (e.g. "Smith", "Baker", etc.) * Date of Birth (e.g. "people born in the year 91") * Membership type ("premium", "standard", etc.) * Emails ("@hotmail.com", "@yahoo.co.uk", etc.) The data sorting can either be: * Ascending (e.g. A, B, C, D, E, etc.) * Descending (e.g. Z, Y, X, W, V, etc.) Report Design Reports are used to create printed results from a database. It is significant to show how the report is to be laid out; header information, main body, footer etc., and the query or data table it is based on. In this case, if a report was created to display those who memberships expire soon, the report will probably be laid out like this: Forename Surname Expiry Date Email Smith Dave 24-Jan-2012 D_smith@gmail.com Barker Joanne 31-Dec-2011 joanne-b@hotmail.com John Ray 2-Jan-2012 JRay@yahoo.co.uk Vader Tina 17-Jan-2012 TinaV@hotmail.co.uk The table has been sorted by ascending order (Surname) ...read more.

Conclusion

Also money is saved as well as being able to create quick result from the database. In addition, it can be easily printed or emailed to one another. It also allows the user to summarise the data as a whole (from all the data in the database). You can generate the reports in various formats (change the look/ style, etc.); this will enhance the understanding of the actual report. Furthermore, it can easily be backed up. In total it is a summary of the information in the report, which can be changed and relevant to your needs (the information needed - not everything, for example title, name, and contact details, however not membership type) When a teenager turns 18, a member of staff from the sports centre needs to change their membership type. This is verification. The day of their 18th birthday a verification box will show on the screen. It will warn the sports centre staff that they are changing to an adult, so they become a different membership type. What is a database design? It's the method of producing an in depth data model of a database. We can think database designs are like flowcharts. Consequently we can it helps us to reach the data simply and understand the database. It's the process of producing a detailed data model of a database. ?? ?? ?? ?? Teja Nareshkumar 11SF ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software 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 GCSE Software essays

  1. The aim of my project is to make the task of the allocation of ...

    change the pricing of any show, all the user must do it click on the square which contains the previous amount and change it to the new amount, this will then do so without any other changes and should not result in anything becoming non-functional. Also the spreadsheet allows Mr.

  2. ICT GCSE Coursework - Documentation.

    But before all this data could be added, I needed to format each field of my database.

  1. The use of IT in producing a news letter.

    As a rough, there will be some graphic design in the newsletter with some pictures as well. Below I have given a rough guide of how the final solution will look like. DESIGN Below I have given the flow chart of how the proposed solution will work.

  2. Database design for a games shop.

    date returned on rentals table Cannot input data 9 Overdue rentals query runs Run query All late/overdue members appear 10 Mail merged letter prints out all correct information from the query fields Print letters Information is printed out correctly 11 Customer search prompts you to search the name of customer

  1. What is a computer registry?

    We recommend that you follow those instructions exactly. Use Registry Editor Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved.

  2. Reviewing different multimedia presentations.

    This is a good feature because what this Multimedia Presentation is trying to do is that is be an educational tool and by getting people to shown where each body part goes does this but what it also does is that its giving this information which is making it more of an educational tool.

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    I selected "COUNTIF" and pressed "ok". 3) Then a "Function Argument" box appeared on the screen, asking what I wanted it to count. In the range box, I clicked on the square icon in the far right corner; this minimised the whole box, so that I could high-light the range of cells I wanted it to look at, without difficulty.

  2. bookings database

    2. Easy to navigate to another task when finished- when you finish checking the details, there are two command buttons at the bottom of the form. This says 'Exit' and 'Add a new guest'. These are very big and apparent so these are effective for the user.

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