{
  "code": null,
  "collection": "architecture",
  "href": "https://banes-lab.com/ontology#architecture-database-normalization",
  "id": "database-normalization",
  "kind": "technique",
  "layer": {
    "href": "https://banes-lab.com/ontology/schema#layer-contracts-core",
    "json": "https://banes-lab.com/json/records/layer/contracts-core",
    "label": "Contracts Core",
    "markdown": "https://banes-lab.com/records/layer/contracts-core.md",
    "ref": "layer:contracts-core"
  },
  "name": "Database Normalization",
  "ref": "architecture:database-normalization",
  "relations": [
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology/lexicon#lexicon-functional-dependencies",
          "json": "https://banes-lab.com/json/records/lexicon/functional-dependencies",
          "label": "Functional Dependencies",
          "markdown": "https://banes-lab.com/records/lexicon/functional-dependencies.md",
          "ref": "lexicon:functional-dependencies"
        }
      ],
      "relation": "requires"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology#architecture-single-source-of-truth",
          "json": "https://banes-lab.com/json/records/architecture/single-source-of-truth",
          "label": "Single Source of Truth",
          "markdown": "https://banes-lab.com/records/architecture/single-source-of-truth.md",
          "ref": "architecture:single-source-of-truth"
        },
        {
          "href": "https://banes-lab.com/ontology/lexicon#lexicon-data-integrity",
          "json": "https://banes-lab.com/json/records/lexicon/data-integrity",
          "label": "Data Integrity",
          "markdown": "https://banes-lab.com/records/lexicon/data-integrity.md",
          "ref": "lexicon:data-integrity"
        }
      ],
      "relation": "reinforces"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology/lexicon#lexicon-non-redundant-storage",
          "json": "https://banes-lab.com/json/records/lexicon/non-redundant-storage",
          "label": "Non-Redundant Storage",
          "markdown": "https://banes-lab.com/records/lexicon/non-redundant-storage.md",
          "ref": "lexicon:non-redundant-storage"
        },
        {
          "href": "https://banes-lab.com/ontology/lexicon#lexicon-non-redundant-storage",
          "json": "https://banes-lab.com/json/records/lexicon/non-redundant-storage",
          "label": "Non-Redundant Storage",
          "markdown": "https://banes-lab.com/records/lexicon/non-redundant-storage.md",
          "ref": "lexicon:non-redundant-storage"
        }
      ],
      "relation": "enables"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology/lexicon#lexicon-duplicated-denormalized-columns",
          "json": "https://banes-lab.com/json/records/lexicon/duplicated-denormalized-columns",
          "label": "Duplicated Denormalized Columns",
          "markdown": "https://banes-lab.com/records/lexicon/duplicated-denormalized-columns.md",
          "ref": "lexicon:duplicated-denormalized-columns"
        }
      ],
      "relation": "conflicts-with"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology/lexicon#lexicon-read-performance",
          "json": "https://banes-lab.com/json/records/lexicon/read-performance",
          "label": "Read Performance",
          "markdown": "https://banes-lab.com/records/lexicon/read-performance.md",
          "ref": "lexicon:read-performance"
        }
      ],
      "relation": "tensions-with"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology/schema#tension-database-normalization-read-performance",
          "json": "https://banes-lab.com/json/records/tension/database-normalization-read-performance",
          "label": "Database Normalization / Read Performance",
          "markdown": "https://banes-lab.com/records/tension/database-normalization-read-performance.md",
          "ref": "tension:database-normalization-read-performance"
        }
      ],
      "relation": "tensions"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology/lexicon#lexicon-duplicated-denormalized-columns",
          "json": "https://banes-lab.com/json/records/lexicon/duplicated-denormalized-columns",
          "label": "Duplicated Denormalized Columns",
          "markdown": "https://banes-lab.com/records/lexicon/duplicated-denormalized-columns.md",
          "ref": "lexicon:duplicated-denormalized-columns"
        }
      ],
      "relation": "violated-by"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology/schema#vocabulary-severity-recommended",
          "json": "https://banes-lab.com/json/records/vocabulary/severity-recommended",
          "label": "recommended",
          "markdown": "https://banes-lab.com/records/vocabulary/severity-recommended.md",
          "ref": "vocabulary:severity-recommended"
        }
      ],
      "relation": "severity"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology#architecture-category-schema-canonical-data-semantics",
          "json": "https://banes-lab.com/json/records/architecture-category/schema-canonical-data-semantics",
          "label": "Schema / Canonical Data / Semantics",
          "markdown": "https://banes-lab.com/records/architecture-category/schema-canonical-data-semantics.md",
          "ref": "architecture-category:schema-canonical-data-semantics"
        }
      ],
      "relation": "category"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology#architecture-normalization",
          "json": "https://banes-lab.com/json/records/architecture/normalization",
          "label": "Normalization",
          "markdown": "https://banes-lab.com/records/architecture/normalization.md",
          "ref": "architecture:normalization"
        }
      ],
      "relation": "refactors"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology#architecture-category-schema-canonical-data-semantics",
          "json": "https://banes-lab.com/json/ontology/principles/architecture-category-schema-canonical-data-semantics",
          "label": "Schema / Canonical Data / Semantics",
          "markdown": "https://banes-lab.com/ontology/principles/architecture-category-schema-canonical-data-semantics.md",
          "ref": "chapter:/ontology#architecture-category-schema-canonical-data-semantics"
        },
        {
          "href": "https://banes-lab.com/ontology/lexicon#lexicon-category-quality-attributes",
          "json": "https://banes-lab.com/json/ontology/lexicon/lexicon-category-quality-attributes",
          "label": "Quality Attributes",
          "markdown": "https://banes-lab.com/ontology/lexicon/lexicon-category-quality-attributes.md",
          "ref": "chapter:/ontology/lexicon#lexicon-category-quality-attributes"
        },
        {
          "href": "https://banes-lab.com/ontology/lexicon#lexicon-category-schema-canonical-data-semantics",
          "json": "https://banes-lab.com/json/ontology/lexicon/lexicon-category-schema-canonical-data-semantics",
          "label": "Schema / Canonical Data / Semantics",
          "markdown": "https://banes-lab.com/ontology/lexicon/lexicon-category-schema-canonical-data-semantics.md",
          "ref": "chapter:/ontology/lexicon#lexicon-category-schema-canonical-data-semantics"
        },
        {
          "href": "https://banes-lab.com/ontology/schema#the-vocabulary-severity",
          "json": "https://banes-lab.com/json/ontology/schema/the-vocabulary-severity",
          "label": "Severity levels",
          "markdown": "https://banes-lab.com/ontology/schema/the-vocabulary-severity.md",
          "ref": "chapter:/ontology/schema#the-vocabulary-severity"
        },
        {
          "href": "https://banes-lab.com/ontology/schema#the-resolutions",
          "json": "https://banes-lab.com/json/ontology/schema/the-resolutions",
          "label": "The resolutions",
          "markdown": "https://banes-lab.com/ontology/schema/the-resolutions.md",
          "ref": "chapter:/ontology/schema#the-resolutions"
        }
      ],
      "relation": "linked-from"
    }
  ],
  "summary": "A technique for decomposing tables by their functional dependencies into normal forms, so no column depends on anything but its key.",
  "siblings": {
    "next": {
      "href": "https://banes-lab.com/ontology#architecture-security-by-design",
      "json": "https://banes-lab.com/json/records/architecture/security-by-design",
      "label": "Security by Design",
      "markdown": "https://banes-lab.com/records/architecture/security-by-design.md",
      "ref": "architecture:security-by-design"
    },
    "previous": {
      "href": "https://banes-lab.com/ontology#architecture-principle-of-least-surprise",
      "json": "https://banes-lab.com/json/records/architecture/principle-of-least-surprise",
      "label": "Principle of Least Surprise",
      "markdown": "https://banes-lab.com/records/architecture/principle-of-least-surprise.md",
      "ref": "architecture:principle-of-least-surprise"
    }
  },
  "up": {
    "href": null,
    "json": "https://banes-lab.com/json/api/records/architecture",
    "label": "Architecture principles",
    "markdown": "https://banes-lab.com/api/records/architecture.md",
    "ref": "api:records/architecture"
  },
  "aliases": [],
  "exemplar": {
    "after": "type Foo = { id: FooId; customerId: CustomerId };\ntype Customer = { id: CustomerId; name: string; cityId: CityId };\ntype City = { id: CityId; name: string; zip: string };",
    "before": "type FooRow = { id: string; customerName: string; customerCity: string; customerCityZip: string };",
    "lang": "ts",
    "medium": "code"
  },
  "formedBy": null,
  "scope": [
    "schema",
    "data modeling",
    "integrity"
  ],
  "severity": "recommended"
}