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

IT GCSE Project 1: Validation

Extracts from this document...


Validation In Order to make my system much more successful. I shall implement validation checks on my dental practise database system. Compulsory Fields The fields with this check makes sure that a patient or member of staff has filled in the necessary information, if the field is not filled in they will receive an error message telling them to input the important information. But this type of validation check does not check for mistake made by the staff/patient therefore this will result in contacting them to give the correct information. I have evidence that this checks for compulsory information. This Evidence shows you that I have not filled in the last name resulting in an error message saying "Field 'LastName' must be filled in". I have applied this check too: LastName, FirstName, Emergency No, Post Code, and House No. I thought it was appropriate to apply this check into these fields because these are the most vital parts of the information needed. This will help to prevent certain errors like making them unable to input anymore information until they fill in the field and will also give us the minimum information to allow us to contact either the staff of patient in order to get the correct information. ...read more.


Check Fields This checks each field for a unique number for example: if you want it so a specific field can only use from numbers 1-100 you would use this check to make this possible. Here is evidence to show that this check works. I applied this check to the following fields: "Patient ID" and set it from 1 to 99. I also applied this check to "Dentist ID" and "Appointment No." For "Dentist ID" I set it from 100 to 200, and for "Appointment No." I set it from 1000 to 9999. the reason I thought it was appropriate to add this check to theses fields is because for "Appointment No." I put a big range because there won't be a limit of how many appointments the dental practice can have but there will always be a limit of how many dentists and how many patients there will be. This check will help to prevent errors. For example, if the person filling the data in was for a patient record and they added a wrong value in that was used in another table such as Dentist or Appointment. ...read more.


to get all of the details from that record and it will be added into the patient link value list automatically same with the dentist link field. The evidence for the dentist and patient link is here. These are the fields from the appointment table when you insert the patient link number from the value list the other details are filled in automatically. This is the part of the record from the patient table this has to be filled out manually but the data is used in other parts to make the database easier to use. The errors this would help to prevent are that it would make it much easier for the person to pick the Name Title just in-case there is a spelling error. It would also help the person making the appointment because they can gather the patient/dentist information into the appointment record without inputting all the information again. The evidence is given in images above. This is not fool proof there is still some errors that can occur because you do not have to use the value list it is just there to help you can still make spelling errors in the field. ?? ?? ?? ?? ...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. a level ict project

    Now the table is in second normal form, as no column that is not part of the primary key is dependant on only part of the primary key. 3rd Normal Form After the reviewing the current table the vehicle name and customer name aren't dependant on the Job ID.

  2. GCSE Calculator Project

    The groups can be "Users" and "Admin". This is very complicated process .For the purpose of this calculator it's acceptable to simply hide the design options from the silver surfers. Design Initial Design User comments User comments on initial design I showed the calculator to a silver surfer and they wrote me a letter.

  1. GCSE Book DataBase Project

    data about students and the books lent out next to each other. The software has to have the "search", "sort" and "query" functions. To query, we can use the Microsoft Excel program. To make the software look good, it must display the results in a professional manner.

  2. I.T. Project : Dental Surgery Filing System

    In order for me to create this however, I have designed a few end user requirements as guidelines to make sure I have an idea of what is required of this system. End User Requirements * The system must be simple for non-technical staff to use and contain a variety

  1. GCSE Database Project ICT

    The receptionist has to go through the 150+ records and check the last appointment date if no appointment has been made in the last 4 months and to send them a letter informing the patient to rebook or face extradition from the surgery list.

  2. Database project

    control method How will it improve the database and make the database user Setting field size for text fields This will keep the size of texts fields as small as possible (instead of the default of 50 characters), resulting in a database file size that is also as small as possible.

  1. ICT Project 1A

    People would again know different things about who was in the band so this information needed to be quite formal. There was some information given on the Klaulitz twins on Wikipedia but there was not anything about Georg or Gustav. So I had to use most of my own knowledge.

  2. Data Validation and Verification

    Once they had finished it I would ask them to check over it to confirm that all the information is correct. If the surgery wasn't busy then I would instead ask them the question in the intend that they can answer the questions for me to put the answers directly in the online system.

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