An I.T. System for Project Skateboarding

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:

1. Show a list of members and their respective details
2. Update the membership list quickly and easily
3. Notify when someone’s membership is outdated
4. Show the current suppliers and their product descriptions
5. Search for a certain member
6. Search for a certain supplier/product

  (Correct at time of printing)