answersLogoWhite

0


Best Answer

Data validation is important, because it ensures the usefulness of your data. There are many examples of situations where a lack of data validation lessens the usefulness of the database.

Imagine a webshop database that would allow you to enter a new customer without an address. You would be unable to ship goods to such a customer.

Imagine that the same webshop database stores the country of residence of its customers. If the database doesn't enforce a certain input pattern on this data you will end up different with values for the same country, like USA, US, United States and The United States of America. This makes it impossible, or at least much harder to extract information like how much customers from the United States have used your webshop, and how many from India..

And what would happen if your database didn't check the minimum length of a phone number? You might end up with a lot of people you can't reach.

These examples are all about actual data, but database can validate more than just data. They can also validate relationships. A database can, for example, prevent a user or program from entering a new order in the Orders table if it is not related (by a key) to an existing customer from the Customers table. Because, where would you send the order if it wasn't tied to an existing customer?

As you can see from these examples, data validation is of great importance to a useful database.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the importance of data validation?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Why do we need data validation?

In order to conduct a research data validation is very necessary. Without the authentic data validation research is incomplete and worthless.


What is batch validation in clinical data management?

batch validation is a programmed validation to achieve valid data. its done after data entry and before data cleaning. batch validation can be over night process or day process.


Is the process of comparing data with a set of rules or values to find out if the data is correct?

Data validation.


What is difference between the data validation and data redundancy?

one is a validation the other is redundancy clue is in the name


What is verifed data?

data validation is when data is collected and stored for after use.


What is the difference between data varification and data validation?

Data validation makes sure that the data is clean, correct and meaningful, while data verification ensures that all copies of the data are as good as the original.


Can anyone share a data validation process?

Data Validation is a process of Cleaning and Validation of the data base. It is performed by checking for inconsistent and misplaced data with the help of electronic and manual checks. A Data Validation Process may include: Removal of invalid information Removal of duplications Identification of missing information Remove typographic, grammatical and punctuation errors


Data validation best refers to?

Data Validation is a process that ensures that data entered into the database form, a web form, or a computer program conforms to the correct data type.


What is field validation?

Field validation ensures that a program or form is using clean incorrect data. A set of validation rules are used to check data that is entered into a system before it is processed.


What are 3 advantages of data validation?

test


What does data validation mean in ict?

if it is valid or not


The Data Validation dialog box is accessed from the group?

On the Data tab in the Data Tools section.