{"schema_version":"4ort.packet/1","entity":{"entity_id":"third-normal-form","kg_uuid":"5fc03a64-6bad-402a-8a44-21bc2fe38432","wikidata_id":"Q311585","name":"third normal form","description":"normalizing a database design to reduce the duplication of data and ensure referential integrity","type":"Thing","url":"https://4ort.xyz/entity/third-normal-form"},"status":"complete","as_of":{"copy_written_at":"2026-11-16T19:52:25Z","last_source_edit_seen":"2026-06-09T07:35:48Z","stale_possible":false,"claims_refreshed_at":"2026-10-25T10:48:19Z","source_revision":2503665585},"facts":[{"field":"P31","label":"instance of","value":"database normalisation","value_id":"Q339072","value_raw":"Q339072","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q311585#P31","source_edition":"2026-10-25T10:48:19Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P61","label":"discoverer or inventor","value":"Edgar F. Codd","value_id":"Q92596","value_raw":"Q92596","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q311585#P61","source_edition":"2026-10-25T10:48:19Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P575","label":"time of discovery or invention","value":"1971","value_id":null,"value_raw":"+1971-00-00T00:00:00Z","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q311585#P575","source_edition":"2026-10-25T10:48:19Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P6366","label":"Microsoft Academic ID (discontinued)","value":"75828265","value_id":null,"value_raw":"75828265","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q311585#P6366","source_edition":"2026-10-25T10:48:19Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P7719","label":"generalization of","value":"second normal form","value_id":"Q277396","value_raw":"Q277396","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q311585#P7719","source_edition":"2026-10-25T10:48:19Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P12946","label":"FOLDOC ID","value":"third+normal+form","value_id":null,"value_raw":"third+normal+form","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q311585#P12946","source_edition":"2026-10-25T10:48:19Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P12946","label":"FOLDOC ID","value":"3NF","value_id":null,"value_raw":"3NF","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q311585#P12946","source_edition":"2026-10-25T10:48:19Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[{"retrieved":"2026-06-09"}]},"trust":{"band":"medium","basis":"wikidata-reference-support/2","calibrated":false}}],"unknowns":[],"omitted":{"facts":0,"reason":null},"licences":[{"source":"wikidata","source_name":"Wikidata","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"fields":["P31","P61","P575","P6366","P7719","P12946"]}],"routes":{"entity_page":"https://4ort.xyz/entity/third-normal-form","packet_api":"https://4ort.xyz/api/v1/entities/third-normal-form/packet","facts_jsonld":"https://4ort.xyz/entity/third-normal-form/facts.json","changes_api":"https://4ort.xyz/api/v1/knowledge/get_entity_changes?entity=third-normal-form","attention_api":"https://4ort.xyz/api/v1/knowledge/get_attention?entity=third-normal-form","wikidata":"https://www.wikidata.org/wiki/Q311585","official_website":null},"trust_rules":{"wikidata-reference-support/2":"From the references in our copy of the statement: high = it cites a source (stated in P248, or a reference URL that is not Wikipedia); medium = only 'imported from Wikimedia project' or a Wikipedia URL; unscored = our copy holds no reference (older copies dropped references, so this is not evidence that Wikidata has none). Wikidata may hold more references than our copy shows. Reference support, not a probability."},"notes":[]}