• 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


    Female 1131 Begum Fahima 04-08-1990 11E Female 1157 Aktar Shahina 07-11-1990 11D Female 1056 Ahmed Ashraf 16-04-1991 11C Male I will also use grade boundaries and colour coded: 85% A* Green 75% A Yellow 65% B Blue 55% C Black 45%+ D Pink 35% E Brown 20% F White 19%

  2. Computer project Alevels

    An error report is produced when an error is detected while validation step is performed. These procedures are frequently taking place, because more patients do come more than any other persons. 5.2. User Documentation 5.2.1. Hardware required by the system * Processor - Intel Pentium(IV) 1800 MHz CPU(Central Processing Unit)

  1. GCSE Database Project ICT

    to be sent out to remind patients who have not booked for 5 to 6 months prior. The user needs the patients Telephone Number, ID, reminder date, Time, Title, Past Treatment Description, Forename, Surname, Address (Town and Postcode) and to print out a report to enable the user to 'tick´┐Ż off the people who have re-booked.

  2. Database project

    Hasan 056 5636 3465 30/05/1991 10 Downing Street London W1 6GT 2 Harold Lucer 078 2890 2098 09/08/1961 12 Man Street Oxford O1 3RR 3 Van Bucer 037 4848 3484 15/03/1979 11 Von Steet Amsterdam K1 023 4 Gustav Stressman 084 3984 4902 16/09/1931 55 Germany Way Berlin T7 OAP

  1. ICT Project 1A

    Bill sings lead vocals in the band and Tom plays the guitar. The twins have many endorsment deals in Germany and are very well-known in their homeland. And on a separate page for Georg and Gustav... Georg Listing plays the bass guitar in the band and was born in Hamburg.


    Therefore I have stepped in to help him with his problems. I will be mainly focusing on year 11 as it is important for them because their about to face their exams. Problems with Current System: By reviewing Mr Shah's problem I have found out what the current common mistakes

  1. GCSE Book DataBase Project

    It is quicker to input information about books, staff, students, and the students' form. Making the database can be time consuming on the computer, as it takes longer to input all the students and books names. The computer is very quick when you're looking to find a particular book.

  2. a level ict project

    For example, if they want to find jobs carried out by a certain employee it will be should be retrieved within a short a amount of time with the entrance of desired filters and a click of a button. Data security will be ensured through the use of this new system.

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