Deleting fields.
A error can cause a deletion of one of fields. It will cause loss of data in the fields and format of the table, If the primary key or the foreign key is deleted it would prevent the data from working correctly in the database. This can be prevented by checking all the data is saved correctly and that nothing was deleted.
Incorrect data types.
If a value is entered in as text, it can effect the remaining data of the database as the value would have no longer have control over the remaining data of the table. To stop this happening you should check that information has been entered in correctly.
Renaming incorrectly.
A mistake can happen when a databases field is being renamed. once you have named the field the data will view the fields name and will go straight to the right field.
Validation.
validation is a way of reducing the amount of data in data base being included in the system, by producing a set of rules. the computer preforms this at the point that data is being entered . it will the check the entered data against the set of rules provided, these rules are set up during the development process of the database.
However a error will occur if the rules are not set correctly or specific enough.also if the database finishes production then you will not be able to go back and change the rules without starting again.
Null values.
a null value would indicate a missing piece of data in a field. the field can contain a null value due to the information not being known. also sometimes a field might not apply information from the record . a null value is not the same as a value of 0, this is because a null value does not have enough information to compare it to any of the other values.
Staff training.
have staff that have been trained correctly and understand how to use the software will help prevent issue from happening that would happen if some one was hired that did not fully understand what they were doing.
Drop down menus
being able to use the drop down menu can help prevent data base errors because when used correctly will give you all options that will have a positive effect on your work and can help reverse and or solve issues that occur.can also be used to stop mull values from being added to the data.
Password for fields.
if a field has a password it would stop strangers from editing the information and only allow those qualified to edit it.
Create a back up.
creating a back up is a super effective way of not worrying about the data in the tables from going corrupted since you have a back up you should be able to begin from there if the data in the original one goes corrupted.
Only full forms can be accepted.
when the forms are submitted but are not fully completed they will create null values in the data based causing incorrect data to form which can cause issues in categorizing in the database.
so only accepting fully filled forms will prevent this from happening. this can be done by using a macro to check if the data being inputted is the correct into the form is correct.
A error can cause a deletion of one of fields. It will cause loss of data in the fields and format of the table, If the primary key or the foreign key is deleted it would prevent the data from working correctly in the database. This can be prevented by checking all the data is saved correctly and that nothing was deleted.
Incorrect data types.
If a value is entered in as text, it can effect the remaining data of the database as the value would have no longer have control over the remaining data of the table. To stop this happening you should check that information has been entered in correctly.
Renaming incorrectly.
A mistake can happen when a databases field is being renamed. once you have named the field the data will view the fields name and will go straight to the right field.
Validation.
validation is a way of reducing the amount of data in data base being included in the system, by producing a set of rules. the computer preforms this at the point that data is being entered . it will the check the entered data against the set of rules provided, these rules are set up during the development process of the database.
However a error will occur if the rules are not set correctly or specific enough.also if the database finishes production then you will not be able to go back and change the rules without starting again.
Null values.
a null value would indicate a missing piece of data in a field. the field can contain a null value due to the information not being known. also sometimes a field might not apply information from the record . a null value is not the same as a value of 0, this is because a null value does not have enough information to compare it to any of the other values.
Staff training.
have staff that have been trained correctly and understand how to use the software will help prevent issue from happening that would happen if some one was hired that did not fully understand what they were doing.
Drop down menus
being able to use the drop down menu can help prevent data base errors because when used correctly will give you all options that will have a positive effect on your work and can help reverse and or solve issues that occur.can also be used to stop mull values from being added to the data.
Password for fields.
if a field has a password it would stop strangers from editing the information and only allow those qualified to edit it.
Create a back up.
creating a back up is a super effective way of not worrying about the data in the tables from going corrupted since you have a back up you should be able to begin from there if the data in the original one goes corrupted.
Only full forms can be accepted.
when the forms are submitted but are not fully completed they will create null values in the data based causing incorrect data to form which can cause issues in categorizing in the database.
so only accepting fully filled forms will prevent this from happening. this can be done by using a macro to check if the data being inputted is the correct into the form is correct.
www: Way too brief for D1.
ReplyDeleteebi's: You missed loads of prevention steps make sure you have mentioned all of the following: staff training; using drop down menus to limit input mistakes; using input masks and forms; password protecting field names so only qualified staff can edit these; backing up so you can re-image corrupt or broken databases; only submitting forms when all fields are filled in to minimise null values.
Well done. Now complete.
ReplyDelete