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/StringLetters, numbers, symbols"John Smith", "A123"
Number/IntegerWhole numbers42, -7, 0
Number/RealDecimal numbers3.14, -2.5
CurrencyMonetary values$19.99, $1,000.00
Date/TimeDates and times01/01/2026, 14:30
BooleanTrue or FalseYes/No, True/False