D1

There is a range of common errors that happen in database design; incorrect data types, accidental deleting of fields, renaming incorrectly, validation and null values.

Deletion of fields
If you accidentally deleted a field, you can back up the database registration if you have it saved from the last time. That way, you can continue from your last check point without losing too much work. Also, you would need to make sure that the right person will be editing your database. The person has to have experience with databases because then they're not gonna delete anything or make mistakes. The person that doesn't have much experience can just add information to the database without having an actual edit bar where you can make some complicated mistakes.

Incorrect data types & Renaming incorrectly
For incorrect data types and renaming incorrectly, you can set up some input masks. You can set it up so it only has to have a certain type of character typed in. For example you can set it up, so you can only write letters in or you can set it up with digits. You can also have a drop down choices/menu. For example if you have a variety of movie genres put together you can just choose from the list (horror, comedy, drama...etc) without typing it in every time. These ways help avoiding renaming things incorrectly.

Validation
You can create validation rules that will limit you with certain amount of letters or digits that you can place in the table. It can check if the data's too long or short. For example, if you were to put a password in, some require a certain amount of characters (6-10 with includes at least one letter or a number). Validation rules would help you to set it up. Other examples of validations are check digit the last two or one digit in a code are used to check the other digits are correct, format check checks the data in the right format, length check checks if the data isn't too long or short, look up table looks up acceptable values in the table and spell check checks if the spelling is correct.


Null values
You can also set up validation rules. If you're filling up a registration form you would have to make sure that every space has been filled in with information, it is not good leaving some boxes empty. Therefore you can also set up an error message so if someone is gonna be leaving one of the boxes empty, you would have an error message popping up asking you to fill up the empty spaces.