• 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. Database design for a games shop.

    should print 18 Games by genre field runs accordingly and is clear Check the form All fields included, English is clear 19 Date rented on rentals sheet is set on current date Customer verification form, date should be today Today's date 20 Long game titles are accepted Enter qwertyuiop Asdfghjkl12345

  2. What is a computer registry?

    Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk. You can use Registry Editor to do the following: * Locate a subtree, key, subkey, or value * Add a subkey or a value * Change a value * Delete a subkey or a value * Rename a subkey or a value The navigation area of Registry Editor displays folders.

  1. Reviewing different multimedia presentations.

    To begin with in this Multimedia Presentation there is no music or sound at all in the whole think which makes it a boring Multimedia Presentation. The reason this is a bad feature is that for it to be an educational tool it needs to keep the interest of the

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

    I inserted the data into the specific criteria boxes: The "Lookup_value" is the cell you want to look up e.g. you may put a student surname in that cell and want it to look it up. The "Table_array" is the cell range your data is in, for it to look it up e.g.

  1. bookings database

    3. Easy to enter the names to be searched- when you click on the 'Find Guest details', a parameter box appears which clearly says 'Enter surname or part of it'. It is efficient for the user as it will save time instead of typing the full name they can enter part of it.

  2. AQA GCSE ICT Specification B

    B: Return to main menu C: Exit 8. View previous orders 9. (Go to 5.) 10. Dates entry form displayed 11. Enter start date 12. Enter end date 13. View Sales summary 14. Choose option: A: Print sales summary B: Return to main menu C: Exit Implementation Hardware and Software Required Hardware Required Acer Extensa 26+17" * Intel Celeron D 430 Processor * (1.8GHz, 800MHz FSB, 512KB Cache)

  1. A presentation for use at information kiosks by the patients at the health centre.

    All this information will aid and guide people into knowing how to contact the health centre and how to use the facility efficiently. The information that the slideshow needs to present are: * Opening Times * Logo * Different services on offer * The heath centre's policies on several subjects (e.g.

  2. ICT BTEC UNIT 2 - REPORT

    Both of these packages seem to be built to make it easier for you and these fantastic packages are: * Adobe Dreamweaver CS3 * Xsite Pro The only thing I would say lets it down for Adobe Dreamweaver is its price at the minimum of �399 which is hardly a

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