Database analysis of ‘my schools swimming club Essay

Background to the companyFor my GCSE project I have based on my schools swimming club. The problems that we ar facing in my club are the numbers of batch are increasing by each year. It is hardened 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 provide be held, which will be free for club members.Details of the current systemAt the moment wholly info is kept on paper, and many files have been used reposition those entropy. 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 saucy 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 clubs compound in case there is a fire.Problems with the current systemMost of the data were been stored by paper and any thing might happen to it. Problems that you will face cant read handwriting, hard to find persons record, lost, mislaid, damaged, stolen, messy to edit, term consuming to write new card, what does she do with old records?, only one index, letters have to be written individually.AnalysisWhat 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 essential?The data will be require 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 requiredThe data will be updated when a new member enters or there is a change in the old members 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 person 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 continue the amount of spaces and time. And the disadvantages will be when you forgot to observe some data, when there is a power cut and 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.SpecificationThings that will be achieve* The customer wouldnt 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 i f 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.FlowchartFirst the application forms are printed out. The clubs 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 mis buzz offs 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 ironwareIn this section Im going to recommend the hardware and software to my end user in a swimming club. Examples Hard drive, Ram, Monitor, Processor, Printer, etc.ComponentsJustificationProcessor-MidAllows the computer to operate lots of files without a long turn back or loadingHard drive- Small Data base and spreadsheet wont take out much space, so I will not need lots of memory in my hard drive.Ram- 256mbOnly a small amount is needed because most work will not take up a lot of spaces.Monitor- Mid flat screenSo that is looks professional and easier to work from.CD- RWSo that I can store more data and back ups for emergency, i.e. Fire, lost, wet.ComponentsReason for choosing themIntel Pentium M processor 740 (1.73GHz, 2Mb L2 Cache, 533MHz FSB)Data can be operates quicker.Hitachi 60GB- Hard driveSo data can be stored without any worries for spaces.Ram- 512MB DDR SDRAM big memory for storing data.Monitor- 17.0 Ultra Sharp Wide Screen XGA (1440* 900) TFT SharpIt will not strain your eyes easily.