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

    We can use create the newsletter very quickly by using the newsletter wizard To use the Newsletter Wizard 1. If the Microsoft Publisher Catalog is not visible, click New on the File menu. 2. Click the Publications by Wizard tab.

  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?

    Back up the registry Before you edit the registry, export the keys in the registry that you plan to edit, or back up the whole registry. If a problem occurs, you can then follow the steps in the "Restore the registry" section to restore the registry to its previous state.

  2. Reviewing different multimedia presentations.

    click the section that you want to so to and it is quite self explanatory what to do and how to make your way through the Multimedia Presentation. 5. Improvements to the multimedia website/product to help meet the product's aims.

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

    did not over the function to prevent it from looking unprofessional Step 15 Once I had completed my conditional formatting, I was then able to count how many cells were green, amber or red in the overall English percentage column; I did this via a "COUNTIF" function.

  2. bookings database

    enter the data and will speed up the time in which the details are entered. This helps provide a better service to the customers as they do not need to spend a lot of time speaking to the receptionist. 2.

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