Data Integrity and Validation Flashcards

1️⃣ Familiarise yourself with the flashcards:

Look through all the flashcards to see what's on both sides.
Make sure you understand the information on each card. If something's unclear, click the link to the revision notes at the bottom of the page for more details.

2️⃣ Test yourself:

Look at the question or prompt on each card and try to remember the answer before flipping it over.
Check the answer and make a note of any cards you find challenging and need to go over more.

3️⃣ Consistently Review and Practice:

Use spaced repetition: spend more time on the cards you struggle with and go over them more often.
Regularly review all the flashcards to help you better understand and retain the information over time.

Note: We may include questions that have multiple correct answers. It's useful to remember specific examples to understand these concepts better.

PERSONALISED 1-TO-1 TUTORING

Get support with clear explanations, practice and feedback (Ages 5 to 16).

Want an ad-free experience? Subscribe to remove ads

What is data integrity?

It means data is accurate, complete, and consistent over time.

Checks that make sure input follows set rules. It does not prove the data is true.

Validation checks data meets rules. Verification checks it matches the source, for example by double entry.

To reduce input errors and keep data quality high.

It makes sure a required field is not left blank.

It makes sure a value is between a set minimum and maximum.

It makes sure the data is the right type, like integer, text, date, or Boolean.

It makes sure the data has the right number of characters.

It makes sure the data matches a pattern, like two letters then four digits.

Every record must have a unique primary key that is not empty.

Each foreign key must match an existing primary key. This stops orphan records.

Each field uses the correct data type and allowed values set by rules.