• 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

  1. System requirements analysis

    I have chosen to use Microsoft Excel as the software that is suitable for making a booking software. Excel is very easy to use and also user friendly. Some training will be required but you will not need to undergo masses of training.

  2. 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.

  1. GCSE Database Project ICT

    Droplet size 3 Pl (minimum) with Variable-sized Droplet Technology Ink system Epson DURABrite(tm) Ultra Ink Print resolution Up to 5760 x 1440 optimised dpi on suitable media using RPM (Resolution Performance Management) Print speed Black text A4 Up to 37 ppm (Fastest), 25 ppm (Business quality)* Colour text A4 Up to 20 ppm (Fastest), 11 ppm (Business quality)* Photo 10x15 cm Approx.

  2. ICT Project 1A

    Gustav Sch�fer was born on the 8 September 1988. He is the drummer of the band and said by the band to be the clown of the group though in the media he seems to be quite profound. MUSIC Obviously the next most important piece of information is the music.


    Year 11 students are studying for GCSE qualification, and they are grading scale are A*, A, B etc. Year 11 student do three tests year these tests help Ms Gammon to decide which grade each student will achieve during GCSE qualification.

  2. Computer project Alevels

    E.g.: MCD123 NAME Text ADDRESS Text TEL NO Number SPECIALIZED FIELD Text FEES Currency HOLIDAY Text MAX APP Number Table - Payments to Doctors Field Name Data type Validation Rule Validation Text DOCTOR NAME Text DOCTOR ID Text Like "MCD###" Text you entered is invalid in the field DOCTOR_NO.

  1. The end user of my program is for the people applying for the insurance ...

    Doyle: We use a paper-based system which is too slow and to be frank is really getting on my last nerve. Me: So all the customers details are just stored in files, that is very risky Doyle: yeah I know that is why it seriously needs to b changed I

  2. In this section I shall design my database. I will make a total of ...

    For example, I will create all my 'Phone Number' fields as text fields. This would also allow the preceding zero at the beginning of the number to be stored, since in a number field it will be eliminated. It will also allow the area code to be contained in brackets,

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