Explains the absence of row order in relational tables

K-662 · Knowledge knobit · Activity: Design the physical data model · Competence: Data modelling

A table is a set: order carries no meaning unless held in a column.

Can AI do this?

Not tested yet

No AI benchmark covers this knobit yet. New results are announced in the Can AI Do the Job? newsletter.

What it looks like in practice

Expected result: A table is a set: order carries no meaning unless held in a column

How it is assessed: Finds facts in sample designs read from row or key order

Related knobits

Needed for

• K-620 Recognises a business fact held in physical row order

All 40 knobits of Design the physical data model.

Source: Data-management practice used by the stage 6 reference and review checklist