Identify the most appropriate method for reducing data entry errors from the descriptions given.
Manually checking the data without reference to the original copy.
How did you do?
Checking that the data being entered is reasonable.
How did you do?
Preventing errors when data is copied from one medium to another.
How did you do?
Did this page help you?
Name an appropriate validation routine for each statement. Each answer must be different.
The last digit in a code used to ensure the other digits have been entered correctly.
How did you do?
This validation routine ensures a password is always 8 characters.
How did you do?
This validation routine ensures data has been entered into a field.
How did you do?
This validation routine ensures that a date is entered as DD/MM/YYYY.
How did you do?
Did this page help you?
A student is working on a project on the World Games. He has produced some information but has decided to produce a second layout including a table. The original layout and the new layout are shown.
2021 World Games
This will be the 11th World Games, a major international multi-sport event, for sports, or disciplines within a sport, that were not contested in the Olympic Games.
Dates: Thu, 15 Jul 2021 – Sun, 25 Jul 2021
Location: Legion Field, Birmingham, Alabama, United States
Host city: Birmingham, Alabama, United States
Opening ceremony: July 15
Closing ceremony: July 25
Main venue: The New Birmingham Stadium
The original layout
2021 World Games
This will be the 11th World Games, a major international multi-sport event, for sports, or disciplines within a sport, that were not contested in the Olympic Games.
Dates | Thu, 15 Jul 2021 – Sun, 25 Jul 2021 |
|---|---|
Location | Legion Field, Birmingham, Alabama, United States |
Host city | Birmingham, Alabama, United States |
Opening ceremony | July 15 |
Closing ceremony | July 25 |
Main venue | The New Birmingham Stadium |
The new layout
The student checks the text he has written using a spell checker.
Explain how a spell checker works
How did you do?
Explain why the suggestions made by the spell checker do not always give the correct response.
How did you do?
Did this page help you?
A library system has two tables; one for borrowers and one for books. Extracts from these tables are shown.
|
|
|
|
|---|---|---|---|
5404 | Susan Stranks | 01632 960321 | |
9867 | Fei Hong Zhao | 07700 900222 |
Borrowers table
|
|
|
|
|
|
|
|---|---|---|---|---|---|---|
1 | 0859550153 | Bird of Prey | David James | 1977 | 5404 | 27/10/2021 |
34 | 3301028345 | The Fifth Man | Colin Turner | 1998 | 9324 | 05/10/2021 |
35 | 4237681321 | A View of the Temple | Yu Yan Zhang | 2017 | 8854 | 07/10/2021 |
54 | 4237681321 | A View of the Temple | Yu Yan Zhang | 2017 | 5404 | 27/10/2021 |
Books table
Name the most appropriate validation check for each of these fields. Your answer must be different for each field.
ISBN
Date_due_back
How did you do?
Did this page help you?
RockIT Airlines representatives use a computer booking system to book flights for customers.
A representative from the airline types in the customer reference number, the number of passengers, departure time, departure date, departure airport and the destination airport.
A customer is planning to take a flight from London Heathrow Airport. The representative types in a code LHR for London Heathrow Airport. One of the reasons for using a code for the airport is to improve data accuracy.
Describe the importance of data accuracy when making a booking.
How did you do?
Did this page help you?
The manager of a medical centre keeps the doctor’s stock records in a database. The stock for any item is not allowed to fall below 15 items and the manager keeps a maximum of 100 items in stock.
The table shows examples of the stock.
|
|
|
|
|
|---|---|---|---|---|
Medihoney | 3081043612211 | 15 | Capimed | 0126 |
Sodium fusidate | 1437210227870 | 60 | Brooks Medical | 0112 |
Crepe bandage | 2541233164353 | 100 | Capimed | 0064 |
Crepe bandage | 2834954736849 | 89 | Cams Meds | 0064 |
As data is entered it needs to be verified and validated.
Explain why verification is carried out
How did you do?
Write down the field name from the table that would be the most appropriate for each of these validation checks. Each answer must be different.
Check digit
Length
Type
How did you do?
Did this page help you?
A librarian in a college department library is entering data into a student borrowers’ file. As the data is entered it needs to be verified.
Describe the two types of verification.
How did you do?
Explain, using examples, why it is necessary to carry out validation as well as verification for this system.
How did you do?
Did this page help you?