Deletion of Fields and Records
- - Deletion of fields and records
are often caused by accident and error on the human user.
- - So Backing up a database insures
that in the event important data is deleted then they could refer back to the
hard copy.
- It is common practice to have a refresh time for a back-up such as
1hr so every hour the back-up renews itself.
- - Multiple copies of a backup could be stored
for added safety and on different formats such as cloud and hard drive.
- -
Human error could also lead to
the corruption or loss of fields so a simple way to prevent this is to use
administrive privileges to ensure on the right people can edit or delete fields
the user is disallowed from entering the database.
Incorrect Data Types
- - input masks (rules) are used often to decrease
incorrect data types being imputed on data forms like signup sheets.
- - Multiply choice questions and
drop down menus increase the accuracy of the information entered into the
database by limiting choice and eliminating the input of fake information. This
makes it easier and quicker for the user to complete a form making a positive
and efficient database.
- - This also helps with naming
stuff incorrectly and ensures the correct grammar and spelling of important
information.
Validation
- - Validation ensures that data put
is correct and clean. This can be done by setting a list of rules in the design
stage of the database which will be used through its life.
- - A simple but ultra-effective limit
checks can be added to reduce or limit the type and the amount of characters
that can be used for a password or user.
- - Range checks which ensure that
the month of birth is between 1-12 and if a age limit is in place the available
years a person can join etc. Grammar checks are also made to insure data is not
spelt wrong which makes letters or personal information easier to use or to
produce.
- - A rule can be set to check
inputted data types, which these ensure that the input data is correct if not an
error message pops up.
- - These are some of the types of
checks/rules that can be added to a database to ensure correct and valid
information/
Null values
- - Null values are very similar to
Validation in the sense of that a list of rules are set when entering information to ensure it is correct and
legitimate.
- - However null values are usually
shown when data is not entered into a specific textbox on the form. This is
classed as important or need to no info such as address or surname
- - if information is not added to the textbox
when considered important then when the press “accept” or “enter” then and
error message pops up to inform them what they have missed because it may be
critical to the database
- - These important areas of
information can be marked different to the other boxes of data with special
signs to clearly mark the out.
