@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix owl: <http://www.w3.org/2002/07/owl#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix schema: <https://schema.org/> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .

<https://knobit.org/id/task/dm-physical-postgres/I5> a edu:Question ;
    rdfs:label "I5 (1 points)"@en ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    owl:sameAs <https://bitbucket.org/reffa/ontology/id/task/dm-physical-postgres/I5> ;
    schema:hasPart <https://knobit.org/id/register/data-modelling#I-622> ;
    schema:identifier "I5" ;
    schema:position 9 ;
    schema:text "Hierarchy encoded redundantly: product_group.path holds ancestor ids as a string, edited by hand, with no foreign key on its parts; reorganising a group rewrites every descendant and a mistyped path loads. parent_product_group_id with a self-referencing foreign key becomes the system of record; a path (or closure table) survives only as a derived structure with a derivation and a DQ rule."@en .

edu:Question rdfs:label "Question"@en,
        "Küsimus"@et .

<https://knobit.org/id/register/data-modelling#I-622> rdfs:label "dm-physical-postgres I5: product group hierarchy as a path string"@en .

