Database analysis of ‘my schools swimming club Essay

Background to the companyFor my GCSE project I excite based on my schools swimming auberge. The problems that we atomic number 18 face up in my club are the numbers of sight are increase by each year. It is located Wolverhampton, and about 80 members are in it. Cost 10 pounds a months. We afford our regular training twice a week, from 4pm to 5pm. almost of our club members are woman and their age r etc. are from 15 to 40. Competitions are held during the Christmas. For every victory in the competitions, discotheque party will be held, which will be needy for club members.Details of the genuine trunkAt the moment all selective information is kept on paper, and many files have been used descent those information. Most of it was create verbally by hand and the spaces in one sheet are limited. Information like name, date of birth and the address, g subverter, cost for each month, etc. Whenever someone new joins, leaves and change in address, we will re- update the entro py of our computer dust again. The data will be all stored in a CD and also keep it outside of the clubs compound in case on that point is a fire.Problems with the current systemMost of the data were been stored by paper and any thing index happen to it. Problems that you will face hind endt read handwriting, unattackable 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.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 bear upon is required?The data will be required to store in the hard drive of the computer. Searches, quires, mail flow 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 ho ld about 100 or 200 records. The main pack who will go on this data will mostly be the receptionist or the club manager. We are going to use the stand but 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 spiritedness much more better and quicker access to data. This allows us to birth 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 deliver a computer based system because.SpecificationThings that will be make* The customer wouldnt have to wait for long, about 5 seconds.* Making our life easier.* Update data qui cker 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.flow diagramFirst the application forms are printed out. The clubs members are asked to engorge them up. The information is then transferred to the pc by typewrite in. After typing in the information, check if it is reasonable. If no, an error message will come forward 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 work there are no mistakes and save the data. Go to mail merge and print off letters to the members.Software and hardwareIn this surgical incision Im going to recommend the hardware and software to my end user in a swimming club. Examples Hard drive, Ram, Monitor, Processor, Printer, etc.Components confessionProcessor-MidAllows the c omputer to operate lots of files without a long delay or loadingHard drive- Small information base and spreadsheet wont take out much space, so I will non 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 subterfugeSo 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 SDRAMBigger memory for storing data.Monitor- 17.0 Ultra Sharp broad Screen XGA (1440* 900) TFT SharpIt will not strain your eyes easily.