They would also like to implement a new system for keeping track of all their suppliers. The current system, which is hand-written, is very slow and unclear. They would like a new database where everything is clear, precise and available at a glance. Their current suppliers are listed as follows:
Clothing: Footwear: Hardware:
TSA Etnies Independent
Pash Emerica Volcom
Peterweth Adio Fury
Combo éS Orion
Susst Hawk Accessories:
Gv DC Eastpak
Chipie
Kronk Decks: Safety Gear:
Tussy Girl Triple Eight
Freshjive Zero
Road World Industries Griptape:
Addict Adio Jessups
Zoo York Unabomber
Bench Toy Machine Wax etc…
Hooch Reaction Powell
Blueprint Flip
Girl Shorty’s
The system which I am proposing is not a very high-tech system, but all that is needed is a database and a printer. Therefore, systems can be purchased for all three areas: the store in Pottinger’s Entry, the park in Ballygowan and, when set up, the park in Glengormely.
I propose that Pentium I’s at 200mhz with 16mb RAM with 3.5” floppy drives and no CD-ROM drive with a dot-matrix, black-and-white printer are purchased. This will be reasonably cheap, and the operating system supplied will come with a database package.
Potential Users
The potential users are the owners of the parks, the managers of the store and any other people involved with membership. Current members should, from time to time, also be able to have read-only access to check if their details are correct. They will want to see membership lists and they will also want lists of their current suppliers.
Outputs
The users will have to able to see at a glance:
- Name of member
- Date of member’s birth
- Address of member
- Date of registration (Membership lasts for one year before having to be renewed) A message will pop up on the screen when this runs out.
- The users will have to search for certain member’s names
- A mail merge system for promotional items, notification of renewing membership
- Current suppliers of products
- Which suppliers supply which products
and print them out if necessary
Inputs
Members:
- Full name
- Address
- Telephone number
- Date of Birth
- Date of registration
Suppliers
- Name of supplier
- Products supplied
- Price of products
- Type of products
Objectives
I want the system to be able to:
- Show a list of members and their respective details
- Update the membership list quickly and easily
- Notify when someone’s membership is outdated
- Show the current suppliers and their product descriptions
- Search for a certain member
- Search for a certain supplier/product
(Correct at time of printing)