Database #3

Front

Why is it important to identify data sources in a database?

Back

Identifying data sources gives credit to the original data providers and allows users to check the database's accuracy.

Front

How has technology impacted data input?

Back

Technology has made data input fast and reliable by minimizing human intervention, saving time, and reducing errors.

Front

What is data accuracy?

Back

Data accuracy is the extent to which data is free from errors, which can be caused by mistakes in gathering or entering data, mismatches, or outdated information.

Front

What are validation checks in a DBMS?

Back

Validation checks ensure that the data entered is acceptable, sensible, or reasonable. They include range check, list check, type check, and check digit.

Front

What is a range check?

Back

A range check is used when data is restricted to a small range of values, such as ensuring a date does not exceed the number of days in a month.

Front

What is a list check?

Back

A list check compares data to a set of accepted data, such as validating state abbreviations.

Front

What is a type check?

Back

A type check determines if the data type is correct, such as ensuring age is entered as a number.

Front

What is a check digit?

Back

A check digit is an extra digit added to a code number, calculated from the other digits, to verify accuracy.

Front

What are verification checks?

Back

Verification checks determine if data is true and accurate, often requiring human intervention, making it slow and expensive.

Front

What is the purpose of a database?

Back

The purpose of a database is to output data in a useful form, transforming it into information.