[VB_user]

hi,
can someone please tell me the definition of data validations tasks. I am thinking this involves checking if the data being inputted is clean (i.e no duplicates, data types are accurately identified primary & foreign keys are in place e.t.c) my thinking is that to ensure this, you would use constraints that you stated during creation of the database.
also my 2nd question..where does these data validation tasks come in when migrating to a new database or trying to move data between two different systems.

[astonecipher]

Sounds like a homework assignment?

[VB_user]

its not a piece of assignment its just basically a job description for a job that i was looking to apply for and that was part of the daily tasks to be carried out

[astonecipher]

Doesn't sound right, but:

Data validation is the process of checking incoming data for clean, correct, needed data in a program.

Question 2: switching from system to system the data should not change, but you have business rules in both systems validating data regardless of where it came from.