The software that the club could use would be pointless if they haven’t got a computer so a PC will have to be bought within a budget. Some of examples are:
Under £500
Dell Dimension L433c = £499
Under £1000
Mesh Elite Business Plus = £992.88
Under £1500
AJP 3300C = £1499
The PC will have to have extra hardware for the tasks that it needs to perform.
Searching
Simple search
A simple search is where you search for one thing e.g. name Mark
- My first search assumes the manager wants to search for people with the surname Kingston.
- My second search assumes the manager wants to search for people who are in between 6’ 2” and 3’ 4”
- My third search assumes the manager wants to search for people who have a zero deck.
Complex search
A complex search is when you search for more than one thing e.g. their name is mark and are less than 5’ 9”.
- My first search assumes the manager wants to search for people named Dave who have abec 7 bearings.
- My second search assumes the manager wants to search for people who where born on 13/12/79 and are over 3’
- My third search assumes the manager wants to search for people whose favourite sport is Football and who sport Manchester United.
Sorting
Simple sorts
A simple sort is when you sort records on one category e.g. weight or forename.
- My first sort assumes that the manager wants to sort the people’s surnames in descending order so he can easily find the person he is looking for.
- My second sort assumes that the manager wants to sort the people’s height in ascending order.
- My third sort assumes that the manager wants to sort the people’s ages in descending order.
Complex sorts
A complex sort is where you sort records on more than one item of information e.g. DOB in ascending order and age in descending order.
- My first sort assumes that the manager wants to sort the people in DoB descending and length of membership.
- My second sort assumes that the manager wants to sort the people’s phone number ascending.
- My third sort assumes that the manager wants to sort the people in height descending and age ascending.
Back-up Procedures
As the Sports shop will have a database that will always be needed, the data will have to be backed-up using these products:
- Zip drive
IOMEGA ZIP 250MB
£129.99
Features:
- 250Mb capacity
- USB interface
- PCMCIA compatible
- Fire wire compatible
- Cd-rewriter
Printing options
The shop will need a printer so it can print the database so they can find people address’s etc.
The printing of the database is an important factor so the shop will need some printing options. For example:
- Whole database
- One field
- Multiple fields
The shop would probably be best off with a fast printer if they were going to print out whole databases. So I would suggest a laser printer.
Here is an example:
MINOLTA DESKLASER MAGICOLOR 2200: it costs £999.99
Data Security
The database could be tampered with so data security will be needed.
You could password files or use encrypting packages to password folders and files as well. The computer could also be virused so an anti-virus program could be used. Here are some that are available:
MCAFEE VIRUS SCAN
Price including VAT
£24.99
Features
— Stop viruses from attacking your PC
— Destroy viruses before they infect
— Get updates for latest protection
— Detect hostile activity
SYMANTEC
Price including VAT
£24.99
Features
— Automatically removes viruses
— Scans & cleans incoming/outgoing e-mails
— Automatic internet updates
— Proactive Script Blocking to stop virus
— A global team of security experts
Input Devices
Input devices will be needed to complete the jobs for the database, these are some input devices, which could be used:
- Mouse
PACKARD BELL INTER MOUSE
Price Inc VAT
£14.99
Features
— 3 buttons
— Scroll function
— Ps2 / USB Connection
— Scroll function
- Scanner
- OMR
- Keyboard
Microsoft Internet keyboard
Features
— Customisable hotkeys
— Direct Internet access
— PS/2 compatible
- Microphone
Computer Processor
Computer processors are needed to complete the job. Saving data, security, editing data, adding, deleting and changing records or data. To do these a program will be needed, I have selected Microsoft Xp office edition for the sports club.
PRICE INCLUDING VAT
£259.99
It features:
System Specification
This is a table showing all the hardware and software the sports club will need to get started, it also includes the prices of the hardware and software.
Questionnaire
Letter
8 May, 2007
721-colbridge road
Hastings
Kent
Me7 5fw
Dear Sir or Madam:
I have designed your database for you and found the suitable equipment, software and programs.
Here is a clear table of the equipment you will need.
In this table there is everything you will need to get the database up and running.
Sincerely,
Kaleem Sajad
Head designer
Validation and Verification
Validation checks to see if the data is acceptable(within an acceptable range) e.g. 18, 30’s holidays.
Verification checks data accuracy by double entering the data. Compares data. E.g. Passwords.
This is the validation rule for my surname field; I have made it so you can only enter text into this field.
Data structure
Program Structure
Testing
User documentation
User guide
How to open file-
Double click on desktop icon called ‘membership’.
How to do a simple search-
Once in the database click on search, then type in what you want to search for.
How to do a complex search-
Once in the database click on search, then type in a number of things you want to search for.
How to do a simple sort-
Once in the database click on a field then click the sort ‘descending’ or ‘ascending’ button.
How to do a complex sort-
Once in the database highlight a number of fields then click the sort ‘descending’ or ‘ascending’ button.
Technical guide
Amending fields- Click on a field then highlight the text in it, then type in what you want the field to say.
Evaluation
In my specification I have said that the user should be able to input data. I have given them sufficient equipment to input the data they need. They have a keyboard and mouse because all they will need to do is open files and type in what they want. In the future I could make this better because if I had suggested other equipment, for example, a microphone they could enter the data without having to use a keyboard if they could use a voice recognition software package. Then they could just say what they want entered and it will type it for them, making it much easier to use.
In my specification I have also said that the user should be able to output data. There is easily enough for what they need to output the data that they need. They have a printer so they can print of information they need, but they also have a Cd-Re writer so if they need to take the information of the computer to take to another computer i.e. a home computer, to amend it.
Also the Cd-Re writer can be used for backing up the software. They obviously have a monitor so they can view the information they need to see.