SubjectPaid lesson
DATA MODELS II
CT
ClassNotes Team 3 MIN READUPDATED 15 JUN 2026DATA PROCESSING SSS2 FIRST TERM
WEEK 3
DATA MODELS II
Contents
TYPES OF DATA MODELLING
Flat Model: The flat Model (or Table) model consists of a single, two-dimensional array of data elements, where all members of a given column are assumed to be similar in values, and all members of the row are assumed to be related to one another.
Flat Model
|
|
Route No. |
Miles |
Activities |
|
RECORD 1 |
1 – 95 |
12 |
Overlay |
|
RECORD 2 |
1 -495 |
05 |
Parching |
|
RECORD 3 |
SR – 301 |
33 |
Crack Seal |
HIERARCHICAL MODEL
In a hierarchical database, data is organized into an upside-down tree-like structure, implying a single upward link in each record to describe the nesting, and a sort field to keep…