@prefix activity: <https://knobit.org/id/activity/> .
@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#> .

<https://knobit.org/id/competence/data-modelling> a edu:Competence ;
    rdfs:label "Data modelling"@en,
        "Andmete modelleerimine"@et ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    rdfs:comment "Data modelling and design end to end (DAMA-DMBOK2 ch. 5) — plan the modelling and its standards, capture data requirements, derive conceptual, logical and physical data models, generate DDL for PostgreSQL, MySQL, Oracle, SQL Server, Snowflake, Databricks or ANSI, review the models with a data model scorecard, reverse-engineer an existing database, and maintain and version models through change, with validation and anomaly checklists gating every stage. Use it whenever the user mentions data requirements, a conceptual/logical/physical data model, entities and attributes, ERDs, normalisation or 3NF, star schemas, dimensional or Kimball modelling, Data Vault, data taxonomies, modelling standards, a model review or scorecard, reverse engineering a schema, model versioning, database schema design, or DDL/CREATE TABLE statements — or hands over a requirements document, a spreadsheet of attributes or an existing schema to turn into a proper data model."@en ;
    owl:sameAs <https://bitbucket.org/reffa/ontology/id/competence/data-modelling> ;
    edu:consistsOf activity:LO-1,
        activity:LO-10,
        activity:LO-11,
        activity:LO-12,
        activity:LO-4,
        activity:LO-5,
        activity:LO-6,
        activity:LO-8,
        activity:LO-9 ;
    edu:relatedTopic <https://knobit.org/id/topic/dmbok2-data-modelling> .

edu:Competence rdfs:label "Competence"@en,
        "Pädevus"@et .

activity:LO-1 rdfs:label "Capture data requirements"@en,
        "Andmenõuete kogumine"@et .

activity:LO-10 rdfs:label "Review the data model against the scorecard"@en,
        "Andmemudeli ülevaatus hindamiskaardi alusel"@et .

activity:LO-11 rdfs:label "Reverse-engineer a model from an existing database"@en,
        "Mudeli pöördprojekteerimine olemasolevast andmebaasist"@et .

activity:LO-12 rdfs:label "Maintain and version data models"@en,
        "Andmemudelite hooldus ja versioonimine"@et .

activity:LO-4 rdfs:label "Build the conceptual model and taxonomies"@en,
        "Kontseptuaalse mudeli ja taksonoomiate koostamine"@et .

activity:LO-5 rdfs:label "Derive the logical data model"@en,
        "Loogilise andmemudeli tuletamine"@et .

activity:LO-6 rdfs:label "Design the physical data model"@en,
        "Füüsilise andmemudeli kujundamine"@et .

activity:LO-8 rdfs:label "Generate and review DDL"@en,
        "DDL-i genereerimine ja ülevaatus"@et .

activity:LO-9 rdfs:label "Plan the modelling and set its standards"@en,
        "Modelleerimise kavandamine ja standardid"@et .

<https://knobit.org/id/topic/dmbok2-data-modelling> rdfs:label "Data modelling and design (DAMA-DMBOK2 chapter 5)"@en,
        "Andmete modelleerimine ja disain (DAMA-DMBOK2 5. peatükk)"@et .