{"id":10703,"date":"2025-01-10T16:59:18","date_gmt":"2025-01-10T08:59:18","guid":{"rendered":"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/"},"modified":"2026-04-14T19:07:43","modified_gmt":"2026-04-14T11:07:43","slug":"understanding-entity-relationship-diagrams-erds-key-concepts-and-types","status":"publish","type":"post","link":"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/","title":{"rendered":"Compreendendo Diagramas Entidade-Relacionamento (ERDs): Conceitos Principais e Tipos"},"content":{"rendered":"<h4>Introdu\u00e7\u00e3o<\/h4>\n<p>Um <a href=\"https:\/\/guides.visual-paradigm.com\/introduction-to-data-modeling-with-visual-paradigm-erd-diagramming-code-generation-and-reverse-engineering\/\">Diagrama Entidade-Relacionamento<\/a> (ERD) \u00e9 uma representa\u00e7\u00e3o visual do modelo de dados de um sistema, ilustrando as entidades, seus atributos e as rela\u00e7\u00f5es entre elas. ERDs s\u00e3o ferramentas essenciais no design de bancos de dados e na an\u00e1lise de sistemas, ajudando a compreender e comunicar a estrutura de um banco de dados. Este artigo explicar\u00e1 os conceitos principais dos ERDs, os tr\u00eas tipos diferentes de ERDs, suas diferen\u00e7as e quando usar cada tipo.<\/p>\n<h4>Conceitos Principais dos ERDs<\/h4>\n<ol>\n<li><strong>Entidades<\/strong>:\n<ul>\n<li>Entidades s\u00e3o objetos ou coisas no mundo real que s\u00e3o distingu\u00edveis de outros objetos. Em um ERD, as entidades s\u00e3o representadas por ret\u00e2ngulos.<\/li>\n<li>Exemplo: Na imagem, \u201cEscola\u201d e \u201cAluno\u201d s\u00e3o entidades.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Atributos<\/strong>:\n<ul>\n<li>Atributos s\u00e3o propriedades ou caracter\u00edsticas das entidades. Eles s\u00e3o representados por ovais ou listados dentro dos ret\u00e2ngulos das entidades.<\/li>\n<li>Exemplo: A entidade \u201cEscola\u201d tem os atributos \u201cnome\u201d e \u201cdesc\u201d, enquanto a entidade \u201cAluno\u201d tem os atributos \u201cnome\u201d e \u201cdata de nascimento.\u201d<\/li>\n<\/ul>\n<\/li>\n<li><strong>Rela\u00e7\u00f5es<\/strong>:\n<ul>\n<li>Rela\u00e7\u00f5es s\u00e3o associa\u00e7\u00f5es entre entidades. Elas s\u00e3o representadas por linhas que conectam as entidades.<\/li>\n<li>Exemplo: A rela\u00e7\u00e3o entre \u201cEscola\u201d e \u201cAluno\u201d indica que os alunos est\u00e3o associados \u00e0s escolas.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chaves Prim\u00e1rias<\/strong>:\n<ul>\n<li>Chaves prim\u00e1rias s\u00e3o atributos que identificam unicamente uma entidade. Elas s\u00e3o frequentemente sublinhadas ou marcadas com um s\u00edmbolo de chave.<\/li>\n<li>Exemplo: No ERD L\u00f3gico, \u201cID\u201d \u00e9 a chave prim\u00e1ria para as entidades \u201cEscola\u201d e \u201cAluno\u201d.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chaves Estrangeiras<\/strong>:\n<ul>\n<li>Chaves estrangeiras s\u00e3o atributos em uma entidade que se referem \u00e0 chave prim\u00e1ria de outra entidade, estabelecendo uma rela\u00e7\u00e3o entre elas.<\/li>\n<li>Exemplo: No ERD L\u00f3gico, \u201cSchoolID\u201d na entidade \u201cAluno\u201d \u00e9 uma chave estrangeira que faz refer\u00eancia ao \u201cID\u201d na entidade \u201cEscola\u201d.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h4>Tr\u00eas Tipos de ERDs<\/h4>\n<p><img alt=\"Introduction to Data Modeling with Visual Paradigm: ERD Diagramming, Code  Generation, and Reverse Engineering - Visual Paradigm Guides\" decoding=\"async\" src=\"https:\/\/www.cybermedian.com\/wp-content\/uploads\/2025\/01\/from-conceptual-to-logical-to-physical-erd.png\"\/><\/p>\n<ol>\n<li><strong>ERD Conceitual<\/strong>:\n<ul>\n<li><strong>Defini\u00e7\u00e3o<\/strong>: Um ERD conceitual fornece uma vis\u00e3o geral de alto n\u00edvel da estrutura do banco de dados, concentrando-se nas entidades principais e em suas rela\u00e7\u00f5es, sem considerar os detalhes da implementa\u00e7\u00e3o do banco de dados.<\/li>\n<li><strong>Prop\u00f3sito<\/strong>: \u00c9 usado nas fases iniciais do projeto de banco de dados para capturar os requisitos essenciais de dados e rela\u00e7\u00f5es.<\/li>\n<li><strong>Exemplo<\/strong>: Na imagem, o ERD conceitual mostra as entidades \u201cEscola\u201d e \u201cAluno\u201d com seus atributos b\u00e1sicos e rela\u00e7\u00f5es.<\/li>\n<li><strong>Quando usar<\/strong>: Use um ERD conceitual durante a fase inicial de planejamento e coleta de requisitos para obter uma compreens\u00e3o ampla do modelo de dados.<\/li>\n<\/ul>\n<\/li>\n<li><strong>ERD L\u00f3gico<\/strong>:\n<ul>\n<li><strong>Defini\u00e7\u00e3o<\/strong>: Um ERD l\u00f3gico fornece uma vis\u00e3o mais detalhada da estrutura do banco de dados, incluindo chaves prim\u00e1rias e estrangeiras, tipos de dados e restri\u00e7\u00f5es.<\/li>\n<li><strong>Prop\u00f3sito<\/strong>: \u00c9 usado para definir a estrutura l\u00f3gica do banco de dados, garantindo a integridade dos dados e a normaliza\u00e7\u00e3o.<\/li>\n<li><strong>Exemplo<\/strong>: Na imagem, o ERD l\u00f3gico inclui o \u201cID\u201d como chave prim\u00e1ria para ambas as entidades \u201cEscola\u201d e \u201cAluno\u201d, e \u201cSchoolID\u201d como chave estrangeira na entidade \u201cAluno\u201d.<\/li>\n<li><strong>Quando usar<\/strong>: Use um ERD l\u00f3gico durante a fase de design detalhado para especificar o modelo de dados com mais detalhes, garantindo que atenda aos requisitos funcionais.<\/li>\n<\/ul>\n<\/li>\n<li><strong>ERD F\u00edsico<\/strong>:\n<ul>\n<li><strong>Defini\u00e7\u00e3o<\/strong>: Um ERD f\u00edsico representa a implementa\u00e7\u00e3o real do banco de dados em um sistema espec\u00edfico de gerenciamento de banco de dados (SGBD), incluindo tabelas, colunas, tipos de dados, \u00edndices e restri\u00e7\u00f5es.<\/li>\n<li><strong>Prop\u00f3sito<\/strong>: \u00c9 usado para definir a estrutura f\u00edsica do banco de dados, otimizando desempenho e armazenamento.<\/li>\n<li><strong>Exemplo<\/strong>: Na imagem, o ERD f\u00edsico mostra as tabelas \u201cEscola\u201d e \u201cAluno\u201d com nomes espec\u00edficos de colunas, tipos de dados e rela\u00e7\u00f5es.<\/li>\n<li><strong>Quando usar<\/strong>: Use um ERD f\u00edsico durante a fase de implementa\u00e7\u00e3o para criar o esquema do banco de dados no SGBD escolhido, garantindo que atenda aos requisitos de desempenho e armazenamento.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h4>Diferen\u00e7as entre os tr\u00eas tipos de ERDs<\/h4>\n<ol>\n<li><strong>N\u00edvel de detalhe<\/strong>:\n<ul>\n<li>ERD Conceitual: Vis\u00e3o geral de alto n\u00edvel, com foco nas entidades principais e rela\u00e7\u00f5es.<\/li>\n<li>ERD L\u00f3gico: Mais detalhado, incluindo chaves prim\u00e1rias e estrangeiras, tipos de dados e restri\u00e7\u00f5es.<\/li>\n<li>ERD F\u00edsico: Mais detalhado, incluindo tabelas, colunas, tipos de dados, \u00edndices e restri\u00e7\u00f5es.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Prop\u00f3sito<\/strong>:\n<ul>\n<li>ERD Conceitual: Capturar requisitos essenciais de dados e rela\u00e7\u00f5es.<\/li>\n<li>ERD L\u00f3gico: Definir a estrutura l\u00f3gica do banco de dados, garantindo integridade dos dados e normaliza\u00e7\u00e3o.<\/li>\n<li>ERD F\u00edsico: Definir a estrutura f\u00edsica do banco de dados, otimizando desempenho e armazenamento.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Uso<\/strong>:\n<ul>\n<li>ERD Conceitual: Usado na fase inicial de planejamento e coleta de requisitos.<\/li>\n<li>ERD L\u00f3gico: Usado na fase de design detalhado.<\/li>\n<li>ERD F\u00edsico: Usado na fase de implementa\u00e7\u00e3o.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h4>Quando usar<a href=\"https:\/\/online.visual-paradigm.com\/knowledge\/visual-modeling\/conceptual-vs-logical-vs-physical-data-model\">Cada tipo de ERD<\/a><\/h4>\n<ol>\n<li><strong>ERD Conceitual<\/strong>:\n<ul>\n<li>Use durante a fase inicial de planejamento e coleta de requisitos para obter uma compreens\u00e3o ampla do modelo de dados.<\/li>\n<li>Adequado para discuss\u00f5es com partes interessadas para capturar requisitos essenciais de dados e rela\u00e7\u00f5es.<\/li>\n<\/ul>\n<\/li>\n<li><strong>ERD L\u00f3gico<\/strong>:\n<ul>\n<li>Use durante a fase de design detalhado para especificar o modelo de dados com mais detalhes, garantindo que atenda aos requisitos funcionais.<\/li>\n<li>Adequado para designers e analistas de banco de dados para definir a estrutura l\u00f3gica do banco de dados.<\/li>\n<\/ul>\n<\/li>\n<li><strong>ERD F\u00edsico<\/strong>:\n<ul>\n<li>Use durante a fase de implementa\u00e7\u00e3o para criar o esquema do banco de dados no SGBD escolhido, garantindo que atenda aos requisitos de desempenho e armazenamento.<\/li>\n<li>Adequado para administradores de banco de dados e desenvolvedores para definir a estrutura f\u00edsica do banco de dados.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h4>Conclus\u00e3o<\/h4>\n<p><a href=\"https:\/\/www.visual-paradigm.com\/support\/documents\/vpuserguide\/3563\/3564\/85375_drawingentit.html\">Diagramas Entidade-Relacionamento<\/a> (ERDs) s\u00e3o ferramentas essenciais no design de bancos de dados e na an\u00e1lise de sistemas, fornecendo uma representa\u00e7\u00e3o visual do modelo de dados. Os tr\u00eas tipos de <a href=\"https:\/\/www.visual-paradigm.com\/support\/documents\/vpuserguide\/3563\/3564\/85378_conceptual,l.html\">ERDs<\/a>\u2014Conceitual, L\u00f3gico e F\u00edsico\u2014servem prop\u00f3sitos diferentes e s\u00e3o usados em est\u00e1gios diferentes do ciclo de vida do desenvolvimento de banco de dados. Compreender os conceitos-chave e as diferen\u00e7as entre esses <a href=\"https:\/\/knowhow.visual-paradigm.com\/database-design\/conceptual-logical-physical-erd\/\">tipos de ERDs<\/a>ajuda a projetar, implementar e gerenciar bancos de dados de forma eficaz. Ao usar o tipo apropriado de ERD em cada est\u00e1gio, voc\u00ea pode garantir que o banco de dados atenda aos requisitos funcionais, de desempenho e de armazenamento, levando a um sistema de banco de dados bem-sucedido e eficiente.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introdu\u00e7\u00e3o Um Diagrama Entidade-Relacionamento (ERD) \u00e9 uma representa\u00e7\u00e3o visual do modelo de dados de um sistema, ilustrando as entidades, seus<\/p>\n","protected":false},"author":1,"featured_media":10704,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_title":"","_yoast_wpseo_metadesc":"","footnotes":""},"categories":[13,3],"tags":[],"class_list":["post-10703","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-online-diagrams","category-unified-modeling-language"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Compreendendo Diagramas Entidade-Relacionamento (ERDs): Conceitos Principais e Tipos - Cibermediano<\/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:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Compreendendo Diagramas Entidade-Relacionamento (ERDs): Conceitos Principais e Tipos - Cibermediano\" \/>\n<meta property=\"og:description\" content=\"Introdu\u00e7\u00e3o Um Diagrama Entidade-Relacionamento (ERD) \u00e9 uma representa\u00e7\u00e3o visual do modelo de dados de um sistema, ilustrando as entidades, seus\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/\" \/>\n<meta property=\"og:site_name\" content=\"Cibermediano\" \/>\n<meta property=\"article:published_time\" content=\"2025-01-10T08:59:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-14T11:07:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/guides.visual-paradigm.com\/wp-content\/uploads\/2023\/03\/from-conceptual-to-logical-to-physical-erd.png\" \/><meta property=\"og:image\" content=\"https:\/\/guides.visual-paradigm.com\/wp-content\/uploads\/2023\/03\/from-conceptual-to-logical-to-physical-erd.png\" \/>\n\t<meta property=\"og:image:width\" content=\"606\" \/>\n\t<meta property=\"og:image:height\" content=\"369\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"vpadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/guides.visual-paradigm.com\/wp-content\/uploads\/2023\/03\/from-conceptual-to-logical-to-physical-erd.png\" \/>\n<meta name=\"twitter:creator\" content=\"@vpadmin\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"vpadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/\"},\"author\":{\"name\":\"vpadmin\",\"@id\":\"https:\/\/www.cybermedian.com\/pt\/#\/schema\/person\/0122cdf8fc3b73482dd8a30c8500f75a\"},\"headline\":\"Compreendendo Diagramas Entidade-Relacionamento (ERDs): Conceitos Principais e Tipos\",\"datePublished\":\"2025-01-10T08:59:18+00:00\",\"dateModified\":\"2026-04-14T11:07:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/\"},\"wordCount\":1047,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.cybermedian.com\/pt\/wp-content\/uploads\/sites\/11\/2026\/02\/from-conceptual-to-logical-to-physical-erd.png\",\"articleSection\":[\"Online Diagrams\",\"Unified Modeling Language\"],\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/\",\"url\":\"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/\",\"name\":\"Compreendendo Diagramas Entidade-Relacionamento (ERDs): Conceitos Principais e Tipos - Cibermediano\",\"isPartOf\":{\"@id\":\"https:\/\/www.cybermedian.com\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.cybermedian.com\/pt\/wp-content\/uploads\/sites\/11\/2026\/02\/from-conceptual-to-logical-to-physical-erd.png\",\"datePublished\":\"2025-01-10T08:59:18+00:00\",\"dateModified\":\"2026-04-14T11:07:43+00:00\",\"author\":{\"@id\":\"https:\/\/www.cybermedian.com\/pt\/#\/schema\/person\/0122cdf8fc3b73482dd8a30c8500f75a\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/#primaryimage\",\"url\":\"https:\/\/www.cybermedian.com\/pt\/wp-content\/uploads\/sites\/11\/2026\/02\/from-conceptual-to-logical-to-physical-erd.png\",\"contentUrl\":\"https:\/\/www.cybermedian.com\/pt\/wp-content\/uploads\/sites\/11\/2026\/02\/from-conceptual-to-logical-to-physical-erd.png\",\"width\":606,\"height\":369},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.cybermedian.com\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Compreendendo Diagramas Entidade-Relacionamento (ERDs): Conceitos Principais e Tipos\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.cybermedian.com\/pt\/#website\",\"url\":\"https:\/\/www.cybermedian.com\/pt\/\",\"name\":\"Cibermediano\",\"description\":\"Aprendendo uma coisa nova todos os dias\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.cybermedian.com\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.cybermedian.com\/pt\/#\/schema\/person\/0122cdf8fc3b73482dd8a30c8500f75a\",\"name\":\"vpadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/www.cybermedian.com\/pt\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3914788226b9b0af628488720662164f4641c6125d0bd38d90ae34f01c8c4ea3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3914788226b9b0af628488720662164f4641c6125d0bd38d90ae34f01c8c4ea3?s=96&d=mm&r=g\",\"caption\":\"vpadmin\"},\"sameAs\":[\"https:\/\/x.com\/vpadmin\"],\"url\":\"https:\/\/www.cybermedian.com\/pt\/author\/vpadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Compreendendo Diagramas Entidade-Relacionamento (ERDs): Conceitos Principais e Tipos - Cibermediano","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:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/","og_locale":"pt_PT","og_type":"article","og_title":"Compreendendo Diagramas Entidade-Relacionamento (ERDs): Conceitos Principais e Tipos - Cibermediano","og_description":"Introdu\u00e7\u00e3o Um Diagrama Entidade-Relacionamento (ERD) \u00e9 uma representa\u00e7\u00e3o visual do modelo de dados de um sistema, ilustrando as entidades, seus","og_url":"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/","og_site_name":"Cibermediano","article_published_time":"2025-01-10T08:59:18+00:00","article_modified_time":"2026-04-14T11:07:43+00:00","og_image":[{"url":"https:\/\/guides.visual-paradigm.com\/wp-content\/uploads\/2023\/03\/from-conceptual-to-logical-to-physical-erd.png","type":"","width":"","height":""},{"width":606,"height":369,"url":"https:\/\/guides.visual-paradigm.com\/wp-content\/uploads\/2023\/03\/from-conceptual-to-logical-to-physical-erd.png","type":"image\/png"}],"author":"vpadmin","twitter_card":"summary_large_image","twitter_image":"https:\/\/guides.visual-paradigm.com\/wp-content\/uploads\/2023\/03\/from-conceptual-to-logical-to-physical-erd.png","twitter_creator":"@vpadmin","twitter_misc":{"Escrito por":"vpadmin","Tempo estimado de leitura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/#article","isPartOf":{"@id":"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/"},"author":{"name":"vpadmin","@id":"https:\/\/www.cybermedian.com\/pt\/#\/schema\/person\/0122cdf8fc3b73482dd8a30c8500f75a"},"headline":"Compreendendo Diagramas Entidade-Relacionamento (ERDs): Conceitos Principais e Tipos","datePublished":"2025-01-10T08:59:18+00:00","dateModified":"2026-04-14T11:07:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/"},"wordCount":1047,"commentCount":0,"image":{"@id":"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cybermedian.com\/pt\/wp-content\/uploads\/sites\/11\/2026\/02\/from-conceptual-to-logical-to-physical-erd.png","articleSection":["Online Diagrams","Unified Modeling Language"],"inLanguage":"pt-PT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/","url":"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/","name":"Compreendendo Diagramas Entidade-Relacionamento (ERDs): Conceitos Principais e Tipos - Cibermediano","isPartOf":{"@id":"https:\/\/www.cybermedian.com\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/#primaryimage"},"image":{"@id":"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cybermedian.com\/pt\/wp-content\/uploads\/sites\/11\/2026\/02\/from-conceptual-to-logical-to-physical-erd.png","datePublished":"2025-01-10T08:59:18+00:00","dateModified":"2026-04-14T11:07:43+00:00","author":{"@id":"https:\/\/www.cybermedian.com\/pt\/#\/schema\/person\/0122cdf8fc3b73482dd8a30c8500f75a"},"breadcrumb":{"@id":"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/#primaryimage","url":"https:\/\/www.cybermedian.com\/pt\/wp-content\/uploads\/sites\/11\/2026\/02\/from-conceptual-to-logical-to-physical-erd.png","contentUrl":"https:\/\/www.cybermedian.com\/pt\/wp-content\/uploads\/sites\/11\/2026\/02\/from-conceptual-to-logical-to-physical-erd.png","width":606,"height":369},{"@type":"BreadcrumbList","@id":"https:\/\/www.cybermedian.com\/pt\/understanding-entity-relationship-diagrams-erds-key-concepts-and-types\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.cybermedian.com\/pt\/"},{"@type":"ListItem","position":2,"name":"Compreendendo Diagramas Entidade-Relacionamento (ERDs): Conceitos Principais e Tipos"}]},{"@type":"WebSite","@id":"https:\/\/www.cybermedian.com\/pt\/#website","url":"https:\/\/www.cybermedian.com\/pt\/","name":"Cibermediano","description":"Aprendendo uma coisa nova todos os dias","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cybermedian.com\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/www.cybermedian.com\/pt\/#\/schema\/person\/0122cdf8fc3b73482dd8a30c8500f75a","name":"vpadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/www.cybermedian.com\/pt\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3914788226b9b0af628488720662164f4641c6125d0bd38d90ae34f01c8c4ea3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3914788226b9b0af628488720662164f4641c6125d0bd38d90ae34f01c8c4ea3?s=96&d=mm&r=g","caption":"vpadmin"},"sameAs":["https:\/\/x.com\/vpadmin"],"url":"https:\/\/www.cybermedian.com\/pt\/author\/vpadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.cybermedian.com\/pt\/wp-json\/wp\/v2\/posts\/10703","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cybermedian.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cybermedian.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cybermedian.com\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cybermedian.com\/pt\/wp-json\/wp\/v2\/comments?post=10703"}],"version-history":[{"count":1,"href":"https:\/\/www.cybermedian.com\/pt\/wp-json\/wp\/v2\/posts\/10703\/revisions"}],"predecessor-version":[{"id":11592,"href":"https:\/\/www.cybermedian.com\/pt\/wp-json\/wp\/v2\/posts\/10703\/revisions\/11592"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cybermedian.com\/pt\/wp-json\/wp\/v2\/media\/10704"}],"wp:attachment":[{"href":"https:\/\/www.cybermedian.com\/pt\/wp-json\/wp\/v2\/media?parent=10703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cybermedian.com\/pt\/wp-json\/wp\/v2\/categories?post=10703"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cybermedian.com\/pt\/wp-json\/wp\/v2\/tags?post=10703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}