story board

p2 unit 43

P1 unit 48

P7

m3

data dictionary

part p5, m3

select query part p5

select query P5

p6, p4, m4, part p5

P4 and P6

p2 p3 m2

d1 

Accidental deletion of fields; 
Data can be stored in different fields and they can also be organised. If you were to delete one of the fields the database would go into a error as the fields and relations would be deleted. By backing up the contents of the database to an external storage device or to another partition of the hard drive you can stop accidental deletion of fields. Another way of stop this is they could cause deletion of fields and whoever is the database author is has the authority to change the database and delete fields.

Incorrect data types;
A way to decrease incorrect data types is on Forms input masks are.Another way do decrease incorrect data types is using multiply choice question. This also allows the data to be entered quicker and makes it easier to complete a data form.  

Renaming incorrectly;
Re-naming something or someone incorrectly on a database can be a huge mistake. This is more than often human error. Unfortunately, unless the glitch is spotted it won’t mend by itself, so the clearest way to avoid this sort of problem would be to double check the information someone is giving you.

Validation; 
Validation is another common error that can come up when using a database. Data can sometimes be put in incorrectly so a way of solving this is creating rules of the database. Some of these rules include only have a limited amount of characters. This is another way of saying the information should be used correctly.

Null values;
A null value equals nothing there and is a blank space on a data sheet. This is a problem as the database will not be able to work properly as it doesn't understand the commands. It  will often have the true false or null option  if the database hasn't been set to understand the option of a null.

m1 updated

p1