Chapter 6 : Data tables Flashcards
Collecting product data. Records and fields. Data types and formats. Calculations. Show bad data. Block bad data.
What are fields?
Fields are the columns of a data table.
What are records?
Records are the rows of a data table?
What is data?
Data is facts and figures.
What is information?
Information is data organised to become more useful.
What is a key field?
A key field is usually the first column of a data table, it is an extra column that stores unique information.
What are the two data types in a data table?
- Text data
- Number values
What is data processing?
Data processing is the process of changing data into information.
What is a the single box in a data table called?
A cell
What is the formula to add cells C2 and C3
= C2+C3
Data fields should be atomic. What does atomic mean?
It means that it can not be split into any smaller parts.
What do fields store?
Fields store one type of data.
What do records store?
Records store information on one object.
State 3 facts about a product and why they are useful for the consumer.
- Size: so that they know what
- ## Colour: so that they can choose their preferred colour.
What is validation?
Validation is a way of checking data.
