• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Construction of a Membership Table

Extracts from this document...


Design Proposed Solution Computerised V Manual? The current system that Project use is a manual system and it has proved inefficient, and very easy to lose. Therefore, I propose a computerised database system. Package V Programming Solution For ease, and speed of use, I propose to use the package option. I choose this because the options for everything the database needs are already there, and rather than waste time trying to find a way to make these options in my own programming solution, I will save much time and effort using the package MS ACCESS 97. Also, my programming skills are next to nothing. The Package: Advantages: * Easier to learn as very little programming is involved * The tools for creating the user interface are already available, built into the program which makes construction of the database far quicker. Disadvantages * Depending on the package, this option could be far more difficult, due to problems such as a lack of flexibility, lack of options etc. The self-programmed solution Advantages: * Program will be specific - all options can be created so that it will do exactly what it needs to do. ...read more.


This is down to insurance reasons. Helmets, however, are not the most fashionable piece of clothing you could ever wear, and many members try to find a way out of getting out of wearing them. Therefore, careful attention must be paid when taking down members' details to make sure that the data is checked against any valid form of identification I.D. number: This is automatically created by the database as a key field. This has a default value of 000, but will increase in value for each new member. Name: This can be checked against any forms of identification, e.g. bus passes, library cards, national insurance cards (if applicable) Date of birth: There is an obvious mistake if someone gives a birth date making them out to be 102. However, minor mistakes, such as a year or two out, can be checked against the DOB's on bus passes, national insurance cards etc. The format will also have to be correct, as it is being entered in the format DD/MM/YY. ...read more.


Name of product supplied: Not only does Project have a large list of suppliers, each supplier also has a list of products supplied to Project. This means that there is a lot of data to do with stock needing to be entered correctly. Again, the only way to do this is visually - making sure there is no mistake when entering in the data. Item number: Every product has a different item number. This insures the "uniqueness" of each product, so that the stock system knows exactly what product is sold. Type of product: Project doesn't just sell skateboards. They sell shoes, clothes, accessories, hardware, safety gear and more. Rather than have to check in the storeroom what a product is, the database can simply tell them. This must have the type entered correctly. The only chance of a typo occurring in this is if I make a mistake during the implementation. The data in this field is selected from a drop-down list. Price of product: If the price is wrong, customers will be over/under charged. This will not be good for Project. If they undercharge, they lose money. If they overcharge, they lose customers. Therefore it is greatly important that the price is entered correctly. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays


    The report will work by using Vlookup formulae, which will be show in three sets of Lookups. These are: looked up and calculated form pivot table B, student names looked up from sheet 10 and grade looked up, using average mark, on sheet 8 Sheet 10-Student List The student list will hold all of the students' details only.

  2. Computer project Alevels

    Therefore, the most suitable Data Base Management System would be MS Access 2003. Operating System Windows XP Professional edition Service Pack 2 1. This is easy to use and more manageable, 2. Less commands are required making the users more comfortable with the system, 3.

  1. GCSE Database Project ICT

    Memory Stick 5 - Friday - Kept at Dentist's house Memory Stick 6 - Saturday - Kept at secretary's house The memory sticks will have a paper label covered in plastic (to prevent wear.) and will be dated for the allocated day.

  2. ICT Project 1A

    Firstly there was the lack of webpage's actually available about them. When I started I was quite lost and was just looking for general information. When I typed in Tokio Hotel Band Google found little over 350,000 websites. Though this seems like quite a lot when I searched for other

  1. Evaluation of a membership card design

    field * There must be a command button linking back to the main page. I have met this by putting a back button on all of my forms so that by pressing this button, it will allow the user to go back to the main page.

  2. System requirements analysis

    the patient's problems or their symptoms that they then send to the doctor to see so that the doctor is aware of this and they have an ides of the problem of the patient and this reduces the amount of time that the patient has to spend in the hospital

  1. a level ict project

    Moreover, the numerous repetitive manual operations does strain the morale of the employees because performing the same task repeatedly is boring since it carries little variation. As a result workers become demoralised and more prone to making mistakes whilst performing task in garage.

  2. ICT car insurance quotation System Coursework

    This will give the dealers that professionalism they like to show their customers. Where did you get the information for your system from? We got the information for car details box, by contacting the Autotrader and asking them if they'd allow us to copy their drop down lists of car makes and models.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work