@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@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-ddl-review-deploy/I6> a edu:Question ;
    rdfs:label "I6 (2 points)"@en ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    schema:hasPart <https://knobit.org/id/register/data-modelling#I-826> ;
    schema:identifier "I6" ;
    schema:position 9 ;
    schema:text "Collation changing what a key means, 1 each: (a) uk_dim_account_nk is on account_number, which arrives upper case without spaces from core banking and lower case in groups of four from the mobile channel; on Postgres (case-sensitive) the two spellings are two accounts, on the SQL Server copy (database default Latin1_General_CI_AS) case is ignored but the spaces still split them - the key's meaning is a server setting nobody chose; (b) the fix makes it a decision in the model: the IBAN normalised on load (upper case, spaces removed) so the key does not depend on collation, with the collation named in physical_options where the engine accepts it."@en .

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

<https://knobit.org/id/register/data-modelling#I-826> rdfs:label "dm-ddl-review-deploy I6: collation deciding what the IBAN key means"@en .