Data Hierarchy & Types
Data Hierarchy
Data is organised in a structured hierarchy from smallest to largest.
Character/Byte → Field → Record → Table/File → Database
- Character/Byte - Single letter, number, or symbol
- Field - Single piece of data (e.g., FirstName, Age)
- Record - Collection of related fields (one row)
- Table/File - Collection of related records
- Database - Collection of related tables
Data Types
| Type | Description | Examples |
|---|---|---|
| Text/String | Letters, numbers, symbols | "John Smith", "A123" |
| Number/Integer | Whole numbers | 42, -7, 0 |
| Number/Real | Decimal numbers | 3.14, -2.5 |
| Currency | Monetary values | $19.99, $1,000.00 |
| Date/Time | Dates and times | 01/01/2026, 14:30 |
| Boolean | True or False | Yes/No, True/False |