VALIDATION IN DATABASES

In Information Systems on Thursday, we learned about validation in databases. Data validation allows you to control what values are entered into a field. We talked about the different types of validation checks and what they are used to do.

These validation checks are :

  • PRESENCE CHECK – Does a field HAVE to have data entered?
  • RESTRICTED CHOICE CHECK – Are there only certain acceptable                                                                             values?
  • RANGE CHECK – Does the data have to be within a certain range?

Here is a link that will send you to a website with all the information on validation within databases. http://www.theteacher99.btinternet.co.uk/theteacher/gcse/newgcse/module5/task10.htm

To ensure that you understood the details in this post, I have put in a link which will send you to a quiz on                                                                                             DATA VALIDATION AND  VERIFICATIONhttp://www.bbc.co.uk/apps/ifl/schools/gcsebitesize/ict/quizengine?quiz=datavalidationverification;templateStyle=ict

By Cammy

Advertisements

Tags: , , ,

One Response to “VALIDATION IN DATABASES”

  1. fhsint2is Says:

    I think this post is much better than the last one

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: