{"id":468,"date":"2023-01-25T13:45:27","date_gmt":"2023-01-25T13:45:27","guid":{"rendered":"http:\/\/learnlearn.uk\/ibcs\/?page_id=468"},"modified":"2024-03-25T09:16:42","modified_gmt":"2024-03-25T09:16:42","slug":"entity-relationship-diagrams","status":"publish","type":"page","link":"https:\/\/learnlearn.uk\/ibcs\/entity-relationship-diagrams\/","title":{"rendered":"Entity Relationship Diagrams"},"content":{"rendered":"<div class=\"responsive-tabs\">\n<h2 class=\"tabtitle\">Introduction<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Types of ERD<\/h3>\n<p>Entity-Relationship Diagrams (ERDs) provide a visual representation of the database structure.<br \/>\nThey facilitate communication among stakeholders, guide the database design process, and serve as documentation for the database schema.<\/p>\n<p>There are three types of Entity Relationship Diagrams &#8211; Conceptual, Logical &amp; Physical.<br \/>\nAs the project progresses and requirements became more defined the ERDs needed will move from Conceptual through to Physical.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone  wp-image-1095\" src=\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/ERD-progression-1024x281.png\" alt=\"\" width=\"944\" height=\"259\" srcset=\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/ERD-progression-1024x281.png 1024w, https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/ERD-progression-300x82.png 300w, https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/ERD-progression-768x210.png 768w, https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/ERD-progression.png 1164w\" sizes=\"(max-width: 944px) 100vw, 944px\" \/><\/p>\n<p>&nbsp;<\/p>\n\n<\/div><h2 class=\"tabtitle\">Conceptual ERD<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Conceptual ERD<\/h3>\n<div id=\"attachment_1096\" style=\"width: 310px\" class=\"wp-caption alignright\"><a href=\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/conceptual-ERD.png\"><img aria-describedby=\"caption-attachment-1096\" decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-1096\" src=\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/conceptual-ERD-300x188.png\" alt=\"\" width=\"300\" height=\"188\" srcset=\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/conceptual-ERD-300x188.png 300w, https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/conceptual-ERD-768x482.png 768w, https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/conceptual-ERD.png 805w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><p id=\"caption-attachment-1096\" class=\"wp-caption-text\">Click to Enlarge<\/p><\/div>\n<ul>\n<li>Focuses on high-level relationships between entities.<\/li>\n<li>Used in the initial stages of database design to capture essential entities and their relationships.<\/li>\n<li>Helps stakeholders understand the scope and requirements of the database system.<\/li>\n<\/ul>\n<p><strong>Used by<\/strong><\/p>\n<ul>\n<li>Business analysts<\/li>\n<li>stakeholders<\/li>\n<li>project managers<\/li>\n<\/ul>\n\n<\/div><h2 class=\"tabtitle\">Logical ERD<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Logical ERD<\/h3>\n<div id=\"attachment_1097\" style=\"width: 310px\" class=\"wp-caption alignright\"><a href=\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/logical-ERD-labelled.png\"><img aria-describedby=\"caption-attachment-1097\" decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-1097\" src=\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/logical-ERD-labelled-300x158.png\" alt=\"\" width=\"300\" height=\"158\" srcset=\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/logical-ERD-labelled-300x158.png 300w, https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/logical-ERD-labelled-768x405.png 768w, https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/logical-ERD-labelled.png 980w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><p id=\"caption-attachment-1097\" class=\"wp-caption-text\">Click to enlarge<\/p><\/div>\n<ul>\n<li>Used to translate the conceptual model into a relational database schema.<\/li>\n<li>Specifies attributes for each entity, defines cardinality (one to one, one to many) and participation(optional vs required) constraints.<\/li>\n<li>Provides a detailed view of the database schema, including primary and foreign keys.<\/li>\n<\/ul>\n<p><strong>Used by<\/strong><\/p>\n<p>Database designers, data architects, developers<\/p>\n\n<\/div><h2 class=\"tabtitle\">Physical ERD<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Physical ERD<\/h3>\n<div id=\"attachment_1098\" style=\"width: 310px\" class=\"wp-caption alignright\"><a href=\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/physical-ERD-Labelled.png\"><img aria-describedby=\"caption-attachment-1098\" decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-1098\" src=\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/physical-ERD-Labelled-300x201.png\" alt=\"\" width=\"300\" height=\"201\" srcset=\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/physical-ERD-Labelled-300x201.png 300w, https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/physical-ERD-Labelled-768x514.png 768w, https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/physical-ERD-Labelled.png 837w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><p id=\"caption-attachment-1098\" class=\"wp-caption-text\">Click to enlarge<\/p><\/div>\n<ul>\n<li>Represents the actual implementation of the database on a specific DBMS in order to to build, optimize, and maintain the physical database schema.<\/li>\n<li>Includes details such as data types, indexes, storage options, and constraints tailored to the chosen DBMS.<\/li>\n<\/ul>\n<p><strong>Used by<\/strong><\/p>\n<ul>\n<li>database administrators<\/li>\n<li>system administrators<\/li>\n<li>developers<\/li>\n<\/ul>\n\n<\/div><h2 class=\"tabtitle\">Video<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Types of ERD Diagram Videos<\/h3>\n<div class=\"nv-iframe-embed\">\n<div class=\"container-lazyload preview-lazyload container-youtube js-lazyload--not-loaded\"><a href=\"https:\/\/www.youtube.com\/watch?v=QG2luqhsCHI\" class=\"lazy-load-youtube preview-lazyload preview-youtube\" data-video-title=\"Conceptual Logical Physical ERDs\" title=\"Play video &quot;Conceptual Logical Physical ERDs&quot;\">https:\/\/www.youtube.com\/watch?v=QG2luqhsCHI<\/a><noscript>Video can&#8217;t be loaded because JavaScript is disabled: <a href=\"https:\/\/www.youtube.com\/watch?v=QG2luqhsCHI\" title=\"Conceptual Logical Physical ERDs\">Conceptual Logical Physical ERDs (https:\/\/www.youtube.com\/watch?v=QG2luqhsCHI)<\/a><\/noscript><\/div>\n<\/div>\n<p>&nbsp;<\/p>\n\n<\/div><h2 class=\"tabtitle\">Resources<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Resources<\/h3>\n<p><a href=\"https:\/\/docs.google.com\/presentation\/d\/1E6VQcSWVfIDPdNyrnaoCaP750deklJF7DvuYtnyCwi4\/edit?usp=sharing\">Types of ERD Google Slides<\/a><\/p>\n<p><a href=\"https:\/\/revise.learnlearn.uk\/app\/dashboard\/4\/75\/161\/1164\">Online Revision Tool<\/a><\/p>\n<p><a href=\"https:\/\/i.pinimg.com\/originals\/f6\/4f\/88\/f64f88ec4e9ae6bc12297551cb6b37f1.jpg\">ERD Symbols<\/a><\/p>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Types of ERD Entity-Relationship Diagrams (ERDs) provide a visual representation of the database structure. They facilitate communication among stakeholders, guide the database design process, and serve as documentation for the database schema. There are three types of Entity Relationship Diagrams &#8211; Conceptual, Logical &amp; Physical. As the project progresses and requirements became more defined the&hellip;&nbsp;<a href=\"https:\/\/learnlearn.uk\/ibcs\/entity-relationship-diagrams\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Entity Relationship Diagrams<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"off","neve_meta_content_width":70,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Entity Relationship Diagrams - IB Computer Science<\/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:\/\/learnlearn.uk\/ibcs\/entity-relationship-diagrams\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Entity Relationship Diagrams - IB Computer Science\" \/>\n<meta property=\"og:description\" content=\"Types of ERD Entity-Relationship Diagrams (ERDs) provide a visual representation of the database structure. They facilitate communication among stakeholders, guide the database design process, and serve as documentation for the database schema. There are three types of Entity Relationship Diagrams &#8211; Conceptual, Logical &amp; Physical. As the project progresses and requirements became more defined the&hellip;&nbsp;Read More &raquo;Entity Relationship Diagrams\" \/>\n<meta property=\"og:url\" content=\"https:\/\/learnlearn.uk\/ibcs\/entity-relationship-diagrams\/\" \/>\n<meta property=\"og:site_name\" content=\"IB Computer Science\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-25T09:16:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/ERD-progression-1024x281.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/entity-relationship-diagrams\/\",\"url\":\"https:\/\/learnlearn.uk\/ibcs\/entity-relationship-diagrams\/\",\"name\":\"Entity Relationship Diagrams - IB Computer Science\",\"isPartOf\":{\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#website\"},\"datePublished\":\"2023-01-25T13:45:27+00:00\",\"dateModified\":\"2024-03-25T09:16:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/entity-relationship-diagrams\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/learnlearn.uk\/ibcs\/entity-relationship-diagrams\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/entity-relationship-diagrams\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"IB Computer Science\",\"item\":\"https:\/\/learnlearn.uk\/ibcs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Entity Relationship Diagrams\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#website\",\"url\":\"https:\/\/learnlearn.uk\/ibcs\/\",\"name\":\"IB Computer Science\",\"description\":\"- learnlearn..uk\",\"publisher\":{\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/learnlearn.uk\/ibcs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#organization\",\"name\":\"IB Computer Science\",\"url\":\"https:\/\/learnlearn.uk\/ibcs\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2022\/09\/LearnLearnLogowhite-300x41.png\",\"contentUrl\":\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2022\/09\/LearnLearnLogowhite-300x41.png\",\"width\":300,\"height\":41,\"caption\":\"IB Computer Science\"},\"image\":{\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Entity Relationship Diagrams - IB Computer Science","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:\/\/learnlearn.uk\/ibcs\/entity-relationship-diagrams\/","og_locale":"en_GB","og_type":"article","og_title":"Entity Relationship Diagrams - IB Computer Science","og_description":"Types of ERD Entity-Relationship Diagrams (ERDs) provide a visual representation of the database structure. They facilitate communication among stakeholders, guide the database design process, and serve as documentation for the database schema. There are three types of Entity Relationship Diagrams &#8211; Conceptual, Logical &amp; Physical. As the project progresses and requirements became more defined the&hellip;&nbsp;Read More &raquo;Entity Relationship Diagrams","og_url":"https:\/\/learnlearn.uk\/ibcs\/entity-relationship-diagrams\/","og_site_name":"IB Computer Science","article_modified_time":"2024-03-25T09:16:42+00:00","og_image":[{"url":"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2024\/03\/ERD-progression-1024x281.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/learnlearn.uk\/ibcs\/entity-relationship-diagrams\/","url":"https:\/\/learnlearn.uk\/ibcs\/entity-relationship-diagrams\/","name":"Entity Relationship Diagrams - IB Computer Science","isPartOf":{"@id":"https:\/\/learnlearn.uk\/ibcs\/#website"},"datePublished":"2023-01-25T13:45:27+00:00","dateModified":"2024-03-25T09:16:42+00:00","breadcrumb":{"@id":"https:\/\/learnlearn.uk\/ibcs\/entity-relationship-diagrams\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/learnlearn.uk\/ibcs\/entity-relationship-diagrams\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/learnlearn.uk\/ibcs\/entity-relationship-diagrams\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"IB Computer Science","item":"https:\/\/learnlearn.uk\/ibcs\/"},{"@type":"ListItem","position":2,"name":"Entity Relationship Diagrams"}]},{"@type":"WebSite","@id":"https:\/\/learnlearn.uk\/ibcs\/#website","url":"https:\/\/learnlearn.uk\/ibcs\/","name":"IB Computer Science","description":"- learnlearn..uk","publisher":{"@id":"https:\/\/learnlearn.uk\/ibcs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/learnlearn.uk\/ibcs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/learnlearn.uk\/ibcs\/#organization","name":"IB Computer Science","url":"https:\/\/learnlearn.uk\/ibcs\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/learnlearn.uk\/ibcs\/#\/schema\/logo\/image\/","url":"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2022\/09\/LearnLearnLogowhite-300x41.png","contentUrl":"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2022\/09\/LearnLearnLogowhite-300x41.png","width":300,"height":41,"caption":"IB Computer Science"},"image":{"@id":"https:\/\/learnlearn.uk\/ibcs\/#\/schema\/logo\/image\/"}}]}},"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"learnlearnadmin","author_link":"https:\/\/learnlearn.uk\/ibcs\/author\/learnlearnadmin\/"},"rttpg_comment":0,"rttpg_category":null,"rttpg_excerpt":"Types of ERD Entity-Relationship Diagrams (ERDs) provide a visual representation of the database structure. They facilitate communication among stakeholders, guide the database design process, and serve as documentation for the database schema. There are three types of Entity Relationship Diagrams &#8211; Conceptual, Logical &amp; Physical. As the project progresses and requirements became more defined the&hellip;&nbsp;Read&hellip;","_links":{"self":[{"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/pages\/468"}],"collection":[{"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/comments?post=468"}],"version-history":[{"count":3,"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/pages\/468\/revisions"}],"predecessor-version":[{"id":1099,"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/pages\/468\/revisions\/1099"}],"wp:attachment":[{"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/media?parent=468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}