Scribd
Upload
5 views1 page

2.2 Data and Databases-Notes

The document discusses the importance of suitable data collection for accuracy and reliability in decision-making, highlighting the consequences of incomplete data. It defines key database concepts such as records and fields, and explains validation checks to ensure data integrity. Additionally, it describes the purpose of data collection forms and the role of wizards in guiding users through database creation.

Uploaded by

g7033097
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views1 page

2.2 Data and Databases-Notes

The document discusses the importance of suitable data collection for accuracy and reliability in decision-making, highlighting the consequences of incomplete data. It defines key database concepts such as records and fields, and explains validation checks to ensure data integrity. Additionally, it describes the purpose of data collection forms and the role of wizards in guiding users through database creation.

Uploaded by

g7033097
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

2.

2 Data and Databases


Notes
1. Why is it important that data collected is suitable for its purpose?
Answer: Data must be collected to ensure accuracy and reliability in decision-
making and analysis.

2. What could happen if data is incomplete or missing?


Answer: Incomplete or missing data can lead to errors, incorrect results, and
poor decisions.

3. What is a record in a database?


Answer: A record is a complete set of related data about one item or object,
consisting of one value for each field in a table.

4. What is a field in a database?


Answer: A field represents one piece of data about an aspect of every record.
Fields are the columns in a database table.

5. What are validation checks and why are they used?


Answer: Validation checks are rules applied to data entry to ensure accuracy and
consistency. They prevent invalid or incorrect data from being stored.

6. Explain different types of validation checks with examples.


Answer:
Validation Check Description
Presence check This is the simplest validation rule that ensures
data is entered (prevents null values).
Format check This validation rule ensures data follows a
specific format (e.g., DD/MM/YYYY for dates).
Length check This validation rule ensures data has the correct
number of characters (e.g., 12 digits for a phone
number).
Range check This validation rule ensures values fall within a
specified range (e.g., between 1 and 10).

7. What is the purpose of a data collection form?


Answer: A data collection form, either paper-based or electronic, is used to
gather data for storage in a database.

8. What is a wizard in computing?


Answer: A wizard is a tool that guides users step-by-step through creating or
configuring something, such as a database or form.

You might also like