Use of Records to Store Data (AQA GCSE Computer Science): Flashcards
📚Flashcards
Practise the cards
13 cards from this deck
ShowHide
Practise the cards
13 cards from this deck
What is a record?
What is a record?
Data structure storing multiple related pieces of info together
What field names are
What field names are
Labels that identify each piece of info in a record
Characteristic of good field names
Characteristic of good field names
Descriptive & clear about the type of info they contain
What each row represents in a database table
What each row represents in a database table
One complete record
What each column represents in a database table
What each column represents in a database table
A different field
What must be done before using records in a program
What must be done before using records in a program
Define their structure (field names & data types)
Purpose of RECORD keyword
Purpose of RECORD keyword
Starts definition & gives the record a name
Purpose of ENDRECORD keyword
Purpose of ENDRECORD keyword
Marks the end of the record definition
When to use String data type
When to use String data type
For text information (names, addresses, emails)
When to use Integer data type
When to use Integer data type
For whole numbers (ages, year groups, quantities)
When to use Boolean data type
When to use Boolean data type
For true/false values
When to use Real/Float data type
When to use Real/Float data type
For decimal numbers (prices, measurements)
Why choosing correct data type matters
Why choosing correct data type matters
Affects how data can be used & processed by the program