@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-logical-integrity/C1> a edu:Question ;
    rdfs:label "C1 (2 points)"@en ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    owl:sameAs <https://bitbucket.org/reffa/ontology/id/task/dm-logical-integrity/C1> ;
    schema:hasPart <https://knobit.org/id/register/data-modelling#I-517> ;
    schema:identifier "C1" ;
    schema:position 1 ;
    schema:text "Customer Advisor Assignment is keyed on (customer, advice area) while BR-111 makes the advisor determine the advice area: a determinant that is not a candidate key, hidden behind the overlapping candidate keys (customer, advice area) and (customer, advisor). 1 for reporting it as a BCNF violation with that dependency named; 1 for the fix: the advice area moves to Advisor and the assignment is keyed on customer and advisor (or the entity stays in 3NF with a waiver naming the accepted update anomaly). Calling it a partial or transitive dependency earns the first point only if the dependency Advisor -> Advice Area is stated."@en .

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

<https://knobit.org/id/register/data-modelling#I-517> rdfs:label "dm-logical-integrity C1: advisor determinant that is not a key (BCNF)"@en .