Explains join dependency and fifth normal form

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

Context functions	Object understanding
Knobit creation methods	AI generated
Knobit types	Knowledge
LCG purposes	Assessing the learner's knowledge or skill state
LCG purposes	Opening up a learning outcome
action verb	Explains en
assessment criterion	Decides for sample three-way entities whether a cyclic rule holds and whether the entity should be decomposed en
assessment method	Written question with sample entities en
conforms to profile	https://oppekava.edu.ee/a/Knobitite_kirjeldamise_ja_seostamise_reeglid#LCG-KNOBIT-0.1
dcterms:identifier	K-559
dcterms:license	https://creativecommons.org/licenses/by/4.0/
dcterms:source	Normalisation theory and relational design (Codd, Fagin, Date), as used by the stage 5 reference and review checklist en
depends on knobit	Explains multivalued dependency and fourth normal form
expected result	When a three-way entity is the join of its projections, and the cyclic rule that makes it so en
owl:sameAs	https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/05-logical/K-559
rdfs:label	Explains join dependency and fifth normal form en
schema:creativeWorkStatus	accepted
schema:isPartOf	Data modelling (DAMA-DMBOK2)
skos:definition	When a three-way entity is the join of its projections, and the cyclic rule that makes it so. en
skos:prefLabel	Explains join dependency and fifth normal form en
target object	join dependency and fifth normal form en

Used by

applies knowledge	Recognises a join dependency kept in one entity
applies knowledge	Recognises a connection trap
depends on knobit	Explains sixth normal form for temporal data
includes knobit	Derives a normalised logical data model and traces anomalies to their causes
includes knobit	Normalisation
includes knobit	Relationship
requires knobit	Derive the logical data model