We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Database analysis of ‘my schools swimming club Essay

Background to the company

For my GCSE project I have based on my school’s swimming club. The problems that we are facing in my club are the numbers of people are increasing by each year. It is located Wolverhampton, and about 80 members are in it. Cost 10 pounds a months. We have our regular training twice a week, from 4pm to 5pm. Most of our club members are woman and their age range are from 15 to 40. Competitions are held during the Christmas. For every victory in the competitions, disco party will be held, which will be free for club members.

Details of the current system

At the moment all information is kept on paper, and many files have been used store those data. Most of it was written by hand and the spaces in one sheet are limited. Information like name, date of birth and the address, gender, cost for each month, etc. Whenever someone new joins, leaves and change in address, we will re- update the data of our computer system again. The data will be all stored in a CD and also keep it outside of the club’s compound in case there is a fire.

We will write a custom essay sample on Database analysis of ‘my schools swimming club specifically for you
for only $16.38 $13.9/page

Order now

Problems with the current system

Most of the data were been stored by paper and any thing might happen to it. Problems that you will face : can’t read handwriting, hard to find persons record, lost, mislaid, damaged, stolen, messy to edit, time consuming to write new card, what does she do with old records?, only one index, letters have to be written individually.

Analysis

What data needs to be entered by the user?

We held our current data in paper, which held date like name, age, sex etc.

What processing is required?

The data will be required to store in the hard drive of the computer. Searches, quires, mail merge and also and pieces of data in order.

What are the output requirements?

Monitor and printers will be required

The data will be updated when a new member enters or there is a change in the old member’s address. They will hold about 100 or 200 records. The main people who will go on this data will mostly be the receptionist or the club manager. We are going to use the stand alone system due to the amount of members we have got in our club. The data should be access straight away when there is someone waiting.

What are the advantages or disadvantages of improving the current system, or introducing new paper base system?

The advantages will be the new system will make our life much more better and quicker access to data. This allows us to save the amount of spaces and time. And the disadvantages will be when you forgot to save some data, when there is a power cut then all the data will be gone and will need to be retyped.

What are the advantages or disadvantages of introducing a computer based system?

I have decided to introduce a computer based system because………….

Specification

Things that will be achieve:

* The customer wouldn’t have to wait for long, about 5 seconds.

* Making our life easier.

* Update data quicker and easily.

* Enable people to look up for information only if they have password.

* More free space when you insert all your data onto the computer.

If I can achieve all of the above my project will be a success.

Flowchart

First the application forms are printed out. The club’s members are asked to fill them up. The information is then transferred to the pc by typing in. After typing in the information, check if it is reasonable. If no, an error message will appear and you have to type in the information again into the pc. If yes, check it against the data with the form. If mistakes appear again then you have to type it up again. Type till there are no mistakes and save the data. Go to mail merge and print off letters to the members.

Software and hardware

In this section I’m going to recommend the hardware and software to my end user in a swimming club. Examples: Hard drive, Ram, Monitor, Processor, Printer, etc.

Components

Justification

Processor-Mid

Allows the computer to operate lots of files without a long delay or loading

Hard drive- Small

Data base and spreadsheet won’t take out much space, so I will not need lots of memory in my hard drive.

Ram- 256mb

Only a small amount is needed because most work will not take up a lot of spaces.

Monitor- Mid flat screen

So that is looks professional and easier to work from.

CD- RW

So that I can store more data and back ups for emergency, i.e. Fire, lost, wet.

Components

Reason for choosing them

Intel Pentium M processor 740 (1.73GHz, 2Mb L2 Cache, 533MHz FSB)

Data can be operates quicker.

Hitachi 60GB- Hard drive

So data can be stored without any worries for spaces.

Ram- 512MB DDR SDRAM

Bigger memory for storing data.

Monitor- 17.0 Ultra Sharp Wide Screen XGA (1440* 900) TFT Sharp

It will not strain your eyes easily.

How to cite this page

Choose cite format:

Database analysis of ‘my schools swimming club. (2017, Sep 27). Retrieved from https://studymoose.com/database-analysis-of-my-schools-swimming-club-essay

We will write a custom essay sample onDatabase analysis of ‘my schools swimming clubspecifically for you

for only $16.38 $13.9/page
Order now

Our customer support team is available Monday-Friday 9am-5pm EST. If you contact us after hours, we'll get back to you in 24 hours or less.

By clicking "Send Message", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.
No results found for “ image
Try Our service
image

Your Answer is very helpful for Us
Thank you a lot!