{"id":156,"date":"2023-10-23T10:36:22","date_gmt":"2023-10-23T08:36:22","guid":{"rendered":"https:\/\/datamodelcollective.eu\/?p=156"},"modified":"2026-03-02T08:13:50","modified_gmt":"2026-03-02T07:13:50","slug":"relational-or-logical","status":"publish","type":"post","link":"https:\/\/datamodelcollective.eu\/index.php\/2023\/10\/23\/relational-or-logical\/","title":{"rendered":"Relational or Logical?"},"content":{"rendered":"
<\/div>

Marco Wobben<\/p><\/div><\/div>\n\n\n

When you’re talking about tables, columns, and foreign keys in the context of a database, you are typically modeling both a relational model and a logical model, and there is a distinction between the two:<\/p>\n\n\n\n

    \n
  1. Relational Model:<\/li>\n<\/ol>\n\n\n\n
      \n
    • The relational model is a theoretical framework for organizing data in a structured way. It was first proposed by Edgar F. Codd in the 1970s. The core concept of the relational model is the use of tables (relations) to represent data, where each table consists of rows (tuples) and columns (attributes).<\/li>\n\n\n\n
    • In the relational model, the emphasis is on the mathematical and theoretical aspects of data organization. It defines the fundamental concepts like relations, attributes, and keys.<\/li>\n<\/ul>\n\n\n\n
        \n
      1. Logical Model:<\/li>\n<\/ol>\n\n\n\n
          \n
        • The logical model, on the other hand, is a practical representation of the relational model tailored to a specific database management system (DBMS) and its implementation. It involves designing database tables, defining columns, specifying data types, and establishing relationships between tables using foreign keys.<\/li>\n\n\n\n
        • The logical model takes into account the physical constraints of a particular DBMS, performance considerations, and other real-world aspects that the relational model doesn’t address.<\/li>\n\n\n\n
        • The logical model is the blueprint for how data will be structured and stored in a specific database system. It includes the creation of tables, indexes, views, and the establishment of constraints like foreign keys.<\/li>\n<\/ul>\n\n\n\n

          In summary, the relational model is a theoretical framework that defines the fundamental concepts of how data should be organized in tables, while the logical model is a practical implementation of the relational model tailored to a specific database system. The logical model translates the abstract concepts of the relational model into concrete structures and relationships that are used to store and manage data in a DBMS.<\/p>\n","protected":false},"excerpt":{"rendered":"

          When you’re talking about tables, columns, and foreign keys in the context of a database, you are typically modeling both a relational model and a logical model, and there is a distinction between the two: In summary, the relational model is a theoretical framework that defines the fundamental concepts of how data should be organized […]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,13],"tags":[32,31],"class_list":["post-156","post","type-post","status-publish","format-standard","hentry","category-blog","category-communication","tag-logical","tag-relational"],"yoast_head":"\nRelational or Logical? - Data Model Collective<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datamodelcollective.eu\/index.php\/2023\/10\/23\/relational-or-logical\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Relational or Logical? - Data Model Collective\" \/>\n<meta property=\"og:description\" content=\"When you’re talking about tables, columns, and foreign keys in the context of a database, you are typically modeling both a relational model and a logical model, and there is a distinction between the two: In summary, the relational model is a theoretical framework that defines the fundamental concepts of how data should be organized […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datamodelcollective.eu\/index.php\/2023\/10\/23\/relational-or-logical\/\" \/>\n<meta property=\"og:site_name\" content=\"Data Model Collective\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-23T08:36:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-02T07:13:50+00:00\" \/>\n<meta name=\"author\" content=\"Marco Wobben\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@marcowobben\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marco Wobben\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/datamodelcollective.eu\\\/index.php\\\/2023\\\/10\\\/23\\\/relational-or-logical\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/datamodelcollective.eu\\\/index.php\\\/2023\\\/10\\\/23\\\/relational-or-logical\\\/\"},\"author\":{\"name\":\"Marco Wobben\",\"@id\":\"https:\\\/\\\/datamodelcollective.eu\\\/#\\\/schema\\\/person\\\/3dcb1f1d3a1c436c0e68d79276f967b5\"},\"headline\":\"Relational or Logical?\",\"datePublished\":\"2023-10-23T08:36:22+00:00\",\"dateModified\":\"2026-03-02T07:13:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/datamodelcollective.eu\\\/index.php\\\/2023\\\/10\\\/23\\\/relational-or-logical\\\/\"},\"wordCount\":292,\"publisher\":{\"@id\":\"https:\\\/\\\/datamodelcollective.eu\\\/#organization\"},\"keywords\":[\"logical\",\"relational\"],\"articleSection\":[\"Blog\",\"Communication\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/datamodelcollective.eu\\\/index.php\\\/2023\\\/10\\\/23\\\/relational-or-logical\\\/\",\"url\":\"https:\\\/\\\/datamodelcollective.eu\\\/index.php\\\/2023\\\/10\\\/23\\\/relational-or-logical\\\/\",\"name\":\"Relational or Logical? - Data Model Collective\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/datamodelcollective.eu\\\/#website\"},\"datePublished\":\"2023-10-23T08:36:22+00:00\",\"dateModified\":\"2026-03-02T07:13:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/datamodelcollective.eu\\\/index.php\\\/2023\\\/10\\\/23\\\/relational-or-logical\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/datamodelcollective.eu\\\/index.php\\\/2023\\\/10\\\/23\\\/relational-or-logical\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/datamodelcollective.eu\\\/index.php\\\/2023\\\/10\\\/23\\\/relational-or-logical\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/datamodelcollective.eu\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Relational or Logical?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/datamodelcollective.eu\\\/#website\",\"url\":\"https:\\\/\\\/datamodelcollective.eu\\\/\",\"name\":\"Data Model Collective\",\"description\":\"Anything you always needed to know about data modeling\",\"publisher\":{\"@id\":\"https:\\\/\\\/datamodelcollective.eu\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/datamodelcollective.eu\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/datamodelcollective.eu\\\/#organization\",\"name\":\"Data Model Collective\",\"url\":\"https:\\\/\\\/datamodelcollective.eu\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/datamodelcollective.eu\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/datamodelcollective.eu\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/cropped-Site-icon.png\",\"contentUrl\":\"https:\\\/\\\/datamodelcollective.eu\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/cropped-Site-icon.png\",\"width\":512,\"height\":512,\"caption\":\"Data Model Collective\"},\"image\":{\"@id\":\"https:\\\/\\\/datamodelcollective.eu\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/datamodelcollective.eu\\\/#\\\/schema\\\/person\\\/3dcb1f1d3a1c436c0e68d79276f967b5\",\"name\":\"Marco Wobben\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d143acc249874417b566d77e036cd72b7154bb415ad005fdcf0c7fa0b16a11ea?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d143acc249874417b566d77e036cd72b7154bb415ad005fdcf0c7fa0b16a11ea?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d143acc249874417b566d77e036cd72b7154bb415ad005fdcf0c7fa0b16a11ea?s=96&d=mm&r=g\",\"caption\":\"Marco Wobben\"},\"description\":\"Marco Wobben is director of BCP Software and has been developing software since the late 80s. He has developed a wide range of applications from off-the-shelve end products, software to remotely operate bridges, automating Data Warehouses, and many back- and front office and web applications. Since 2001 he is product manager and lead developer of CaseTalk, the CASE tool for fact oriented information modeling, used in large enterprises and small consultancy projects. It supports FCO-IM, which is widely thought in schools and universities in the Netherlands and across the globe.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/wobben\\\/\",\"https:\\\/\\\/x.com\\\/marcowobben\"],\"url\":\"https:\\\/\\\/datamodelcollective.eu\\\/index.php\\\/author\\\/marco\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Relational or Logical? - Data Model Collective","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datamodelcollective.eu\/index.php\/2023\/10\/23\/relational-or-logical\/","og_locale":"en_GB","og_type":"article","og_title":"Relational or Logical? - Data Model Collective","og_description":"When you’re talking about tables, columns, and foreign keys in the context of a database, you are typically modeling both a relational model and a logical model, and there is a distinction between the two: In summary, the relational model is a theoretical framework that defines the fundamental concepts of how data should be organized […]","og_url":"https:\/\/datamodelcollective.eu\/index.php\/2023\/10\/23\/relational-or-logical\/","og_site_name":"Data Model Collective","article_published_time":"2023-10-23T08:36:22+00:00","article_modified_time":"2026-03-02T07:13:50+00:00","author":"Marco Wobben","twitter_card":"summary_large_image","twitter_creator":"@marcowobben","twitter_misc":{"Written by":"Marco Wobben","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datamodelcollective.eu\/index.php\/2023\/10\/23\/relational-or-logical\/#article","isPartOf":{"@id":"https:\/\/datamodelcollective.eu\/index.php\/2023\/10\/23\/relational-or-logical\/"},"author":{"name":"Marco Wobben","@id":"https:\/\/datamodelcollective.eu\/#\/schema\/person\/3dcb1f1d3a1c436c0e68d79276f967b5"},"headline":"Relational or Logical?","datePublished":"2023-10-23T08:36:22+00:00","dateModified":"2026-03-02T07:13:50+00:00","mainEntityOfPage":{"@id":"https:\/\/datamodelcollective.eu\/index.php\/2023\/10\/23\/relational-or-logical\/"},"wordCount":292,"publisher":{"@id":"https:\/\/datamodelcollective.eu\/#organization"},"keywords":["logical","relational"],"articleSection":["Blog","Communication"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/datamodelcollective.eu\/index.php\/2023\/10\/23\/relational-or-logical\/","url":"https:\/\/datamodelcollective.eu\/index.php\/2023\/10\/23\/relational-or-logical\/","name":"Relational or Logical? - Data Model Collective","isPartOf":{"@id":"https:\/\/datamodelcollective.eu\/#website"},"datePublished":"2023-10-23T08:36:22+00:00","dateModified":"2026-03-02T07:13:50+00:00","breadcrumb":{"@id":"https:\/\/datamodelcollective.eu\/index.php\/2023\/10\/23\/relational-or-logical\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datamodelcollective.eu\/index.php\/2023\/10\/23\/relational-or-logical\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/datamodelcollective.eu\/index.php\/2023\/10\/23\/relational-or-logical\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/datamodelcollective.eu\/"},{"@type":"ListItem","position":2,"name":"Relational or Logical?"}]},{"@type":"WebSite","@id":"https:\/\/datamodelcollective.eu\/#website","url":"https:\/\/datamodelcollective.eu\/","name":"Data Model Collective","description":"Anything you always needed to know about data modeling","publisher":{"@id":"https:\/\/datamodelcollective.eu\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datamodelcollective.eu\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datamodelcollective.eu\/#organization","name":"Data Model Collective","url":"https:\/\/datamodelcollective.eu\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datamodelcollective.eu\/#\/schema\/logo\/image\/","url":"https:\/\/datamodelcollective.eu\/wp-content\/uploads\/2022\/06\/cropped-Site-icon.png","contentUrl":"https:\/\/datamodelcollective.eu\/wp-content\/uploads\/2022\/06\/cropped-Site-icon.png","width":512,"height":512,"caption":"Data Model Collective"},"image":{"@id":"https:\/\/datamodelcollective.eu\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/datamodelcollective.eu\/#\/schema\/person\/3dcb1f1d3a1c436c0e68d79276f967b5","name":"Marco Wobben","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/d143acc249874417b566d77e036cd72b7154bb415ad005fdcf0c7fa0b16a11ea?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d143acc249874417b566d77e036cd72b7154bb415ad005fdcf0c7fa0b16a11ea?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d143acc249874417b566d77e036cd72b7154bb415ad005fdcf0c7fa0b16a11ea?s=96&d=mm&r=g","caption":"Marco Wobben"},"description":"Marco Wobben is director of BCP Software and has been developing software since the late 80s. He has developed a wide range of applications from off-the-shelve end products, software to remotely operate bridges, automating Data Warehouses, and many back- and front office and web applications. Since 2001 he is product manager and lead developer of CaseTalk, the CASE tool for fact oriented information modeling, used in large enterprises and small consultancy projects. It supports FCO-IM, which is widely thought in schools and universities in the Netherlands and across the globe.","sameAs":["https:\/\/www.linkedin.com\/in\/wobben\/","https:\/\/x.com\/marcowobben"],"url":"https:\/\/datamodelcollective.eu\/index.php\/author\/marco\/"}]}},"_links":{"self":[{"href":"https:\/\/datamodelcollective.eu\/index.php\/wp-json\/wp\/v2\/posts\/156","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datamodelcollective.eu\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datamodelcollective.eu\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datamodelcollective.eu\/index.php\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/datamodelcollective.eu\/index.php\/wp-json\/wp\/v2\/comments?post=156"}],"version-history":[{"count":2,"href":"https:\/\/datamodelcollective.eu\/index.php\/wp-json\/wp\/v2\/posts\/156\/revisions"}],"predecessor-version":[{"id":190,"href":"https:\/\/datamodelcollective.eu\/index.php\/wp-json\/wp\/v2\/posts\/156\/revisions\/190"}],"wp:attachment":[{"href":"https:\/\/datamodelcollective.eu\/index.php\/wp-json\/wp\/v2\/media?parent=156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datamodelcollective.eu\/index.php\/wp-json\/wp\/v2\/categories?post=156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datamodelcollective.eu\/index.php\/wp-json\/wp\/v2\/tags?post=156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}