Recognises a business fact held in physical row order

https://knobit.org/id/knobit/K-620

Also as Turtle · JSON-LD · RDF/XML · AI benchmark on Skilirium

Context functions	Result evaluation
Knobit creation methods	AI generated, human edited
Knobit types	Skill
LCG purposes	Assessing the learner's knowledge or skill state
LCG purposes	Selecting an assessment task or learning activity
action verb	Recognises en
applies knowledge	Explains the absence of row order in relational tables
assessment criterion	Flags the deficient case and passes the acceptable one. Deficient: "The current address is the one with the highest `address_id`"; "payments in order of booking" read from identity order Acceptable: `booked_at`, `valid_from` or a version number as columns, and the current row identified by its data en
assessment method	skill-tests task: Loan application physical model on Snowflake (physical design anomaly skills) en
conforms to profile	https://oppekava.edu.ee/a/Knobitite_kirjeldamise_ja_seostamise_reeglid#LCG-KNOBIT-0.1
dcterms:identifier	K-620
dcterms:license	https://creativecommons.org/licenses/by/4.0/
dcterms:source	Review checklist 04-physical, row 20; Codd 1970 §1.2 en
expected result	The fact and the column to hold it en
owl:sameAs	https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/06-physical/20
rdfs:label	Recognises a business fact held in physical row order en
schema:creativeWorkStatus	accepted
schema:isPartOf	Data modelling (DAMA-DMBOK2)
skos:altLabel	Meaning held in physical order (physical model) en
skos:definition	A business fact read from row order, insertion order or the order of generated key values rather than from a column. It changes with parallel loads, sequence caching, reorganisation or migration. en
skos:prefLabel	Recognises a business fact held in physical row order en
target object	fact read from row or key order en

Used by

includes knobit	Designs a physical data model for the target platform without introducing anomalies
requires knobit	Design the physical data model