{"id":911,"date":"2024-11-07T00:57:17","date_gmt":"2024-11-07T00:57:17","guid":{"rendered":"https:\/\/gurututorku.com\/blog\/?p=911"},"modified":"2024-11-07T02:08:35","modified_gmt":"2024-11-07T02:08:35","slug":"entity-relationship-diagram-erd-basis-data-episode-3","status":"publish","type":"post","link":"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/","title":{"rendered":"Entity Relationship Diagram (ERD) Basis Data – Episode 3"},"content":{"rendered":"\n

Entity Relationship Diagram (ERD) adalah diagram yang digunakan untuk memodelkan struktur basis data dengan menggambarkan entitas (objek atau tabel) dan hubungan (relasi) antar entitas. ERD membantu dalam perencanaan basis data, karena menunjukkan bagaimana data akan diorganisasikan dan bagaimana tabel-tabel akan saling berinteraksi.<\/h3>\n\n\n\n

Dalam ERD, terdapat beberapa komponen utama:<\/p>\n\n\n\n

    \n
  1. Entitas<\/strong>: Objek utama yang akan disimpan informasinya dalam basis data, seperti Customer<\/em>, Product<\/em>, atau Order<\/em>. Dalam diagram, entitas digambarkan sebagai persegi panjang.<\/li>\n\n\n\n
  2. Atribut<\/strong>: Karakteristik atau properti dari entitas, seperti nama, alamat, atau ID. Atribut biasanya digambarkan sebagai oval yang terhubung ke entitas.<\/li>\n\n\n\n
  3. Relasi<\/strong>: Hubungan antara dua atau lebih entitas. Relasi menunjukkan bagaimana entitas tersebut saling terkait, misalnya, Customer<\/em> dapat membuat Order<\/em>. Relasi digambarkan sebagai garis yang menghubungkan dua entitas dan dapat menyertakan jenis relasi, seperti satu ke satu (1:1), satu ke banyak (1), atau banyak ke banyak (M).<\/li>\n<\/ol>\n\n\n\n

    Jenis Relasi dalam ERD<\/strong>:<\/p>\n\n\n\n

      \n
    • One-to-One (1:1)<\/strong>: Setiap entitas dalam satu tabel hanya dapat berhubungan dengan satu entitas dalam tabel lain.<\/li>\n\n\n\n
    • One-to-Many (1)<\/strong>: Satu entitas dalam sebuah tabel dapat berhubungan dengan banyak entitas di tabel lain.<\/li>\n\n\n\n
    • Many-to-Many (M)<\/strong>: Banyak entitas dalam satu tabel bisa berhubungan dengan banyak entitas di tabel lain. Namun, relasi ini biasanya perlu dipecah dengan tabel tambahan untuk memenuhi normalisasi.<\/li>\n<\/ul>\n\n\n\n

      ERD membantu dalam merancang basis data yang efisien dan konsisten, karena memberikan pandangan menyeluruh tentang struktur dan hubungan antar data yang akan digunakan.<\/p>\n\n\n\n

      Referensi Lainnya :<\/strong><\/p>\n\n\n\n

        \n
      • https:\/\/drive.google.com\/file\/d\/1UYpBqnFGI5xBpoW7FMeQJahQ18GlJCCG\/view?usp=classroom_web&authuser=0<\/li>\n\n\n\n
      • https:\/\/drive.google.com\/file\/d\/1Dd9XN_NLq0BGRlHp-5jvsI0AJRJh-7iP\/view?usp=classroom_web&authuser=0<\/li>\n\n\n\n
      • https:\/\/medium.com\/@fahmisyaifudin35\/relasi-tabel-database-one-to-one-one-to-many-many-to-many-44010f703f57?authuser=0<\/li>\n\n\n\n
      • https:\/\/www.studipedia.net\/2020\/06\/pembahasan-lengkap-diagram-hubungan-entitas.html?authuser=0<\/li>\n\n\n\n
      • https:\/\/drive.google.com\/file\/d\/1FFoO_ZaZ4c_nmDI_VI3E8CF9A9WpCe_F\/view?usp=classroom_web&authuser=0<\/li>\n\n\n\n
      • https:\/\/drive.google.com\/file\/d\/1rUBAsGwv5RqlvUBrcRmKDjAkbhMLjasT\/view?usp=classroom_web&authuser=0<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

        Entity Relationship Diagram (ERD) adalah diagram yang digunakan untuk memodelkan struktur basis data dengan menggambarkan entitas (objek atau tabel) dan hubungan (relasi) antar entitas. ERD membantu dalam perencanaan basis data, karena menunjukkan bagaimana data akan diorganisasikan dan bagaimana tabel-tabel akan saling berinteraksi. Dalam ERD, terdapat beberapa komponen utama: Jenis Relasi dalam ERD: ERD membantu dalam […]<\/p>\n","protected":false},"author":1,"featured_media":905,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[53,68],"tags":[54,55,60,61,63,64,21,57,58],"class_list":["post-911","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-lainnya","tag-basis-data","tag-database","tag-erd","tag-erd-basis-data","tag-erd-chen","tag-erd-crows-foot","tag-laragon","tag-mysql","tag-sql"],"yoast_head":"\nEntity Relationship Diagram (ERD) Basis Data - Episode 3 - Gurututorku<\/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:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Entity Relationship Diagram (ERD) Basis Data - Episode 3 - Gurututorku\" \/>\n<meta property=\"og:description\" content=\"Entity Relationship Diagram (ERD) adalah diagram yang digunakan untuk memodelkan struktur basis data dengan menggambarkan entitas (objek atau tabel) dan hubungan (relasi) antar entitas. ERD membantu dalam perencanaan basis data, karena menunjukkan bagaimana data akan diorganisasikan dan bagaimana tabel-tabel akan saling berinteraksi. Dalam ERD, terdapat beberapa komponen utama: Jenis Relasi dalam ERD: ERD membantu dalam […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/\" \/>\n<meta property=\"og:site_name\" content=\"Gurututorku\" \/>\n<meta property=\"article:published_time\" content=\"2024-11-07T00:57:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-07T02:08:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"750\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"gtadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"gtadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. 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:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/\"},\"author\":{\"name\":\"gtadmin\",\"@id\":\"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2\"},\"headline\":\"Entity Relationship Diagram (ERD) Basis Data – Episode 3\",\"datePublished\":\"2024-11-07T00:57:17+00:00\",\"dateModified\":\"2024-11-07T02:08:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/\"},\"wordCount\":313,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2\"},\"image\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png\",\"keywords\":[\"basis data\",\"database\",\"erd\",\"erd basis data\",\"erd chen\",\"erd crows foot\",\"laragon\",\"mysql\",\"sql\"],\"articleSection\":[\"Database\",\"Lainnya\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/\",\"url\":\"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/\",\"name\":\"Entity Relationship Diagram (ERD) Basis Data - Episode 3 - Gurututorku\",\"isPartOf\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png\",\"datePublished\":\"2024-11-07T00:57:17+00:00\",\"dateModified\":\"2024-11-07T02:08:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/#primaryimage\",\"url\":\"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png\",\"contentUrl\":\"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png\",\"width\":1000,\"height\":750},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/gurututorku.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Entity Relationship Diagram (ERD) Basis Data – Episode 3\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/gurututorku.com\/blog\/#website\",\"url\":\"https:\/\/gurututorku.com\/blog\/\",\"name\":\"Gurututorku - Learning today success tomorrow\",\"description\":\"Kelas dan Kursus Programming, Design, Multimedia dan Tutorial IT lainnya.\",\"publisher\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/gurututorku.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2\",\"name\":\"gtadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/cropped-gurututorku-favicon.png\",\"contentUrl\":\"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/cropped-gurututorku-favicon.png\",\"width\":512,\"height\":512,\"caption\":\"gtadmin\"},\"logo\":{\"@id\":\"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/gurututorku.com\/blog\"],\"url\":\"https:\/\/gurututorku.com\/blog\/author\/gtadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Entity Relationship Diagram (ERD) Basis Data - Episode 3 - Gurututorku","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:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/","og_locale":"en_US","og_type":"article","og_title":"Entity Relationship Diagram (ERD) Basis Data - Episode 3 - Gurututorku","og_description":"Entity Relationship Diagram (ERD) adalah diagram yang digunakan untuk memodelkan struktur basis data dengan menggambarkan entitas (objek atau tabel) dan hubungan (relasi) antar entitas. ERD membantu dalam perencanaan basis data, karena menunjukkan bagaimana data akan diorganisasikan dan bagaimana tabel-tabel akan saling berinteraksi. Dalam ERD, terdapat beberapa komponen utama: Jenis Relasi dalam ERD: ERD membantu dalam […]","og_url":"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/","og_site_name":"Gurututorku","article_published_time":"2024-11-07T00:57:17+00:00","article_modified_time":"2024-11-07T02:08:35+00:00","og_image":[{"width":1000,"height":750,"url":"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png","type":"image\/png"}],"author":"gtadmin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"gtadmin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/#article","isPartOf":{"@id":"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/"},"author":{"name":"gtadmin","@id":"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2"},"headline":"Entity Relationship Diagram (ERD) Basis Data – Episode 3","datePublished":"2024-11-07T00:57:17+00:00","dateModified":"2024-11-07T02:08:35+00:00","mainEntityOfPage":{"@id":"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/"},"wordCount":313,"commentCount":0,"publisher":{"@id":"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2"},"image":{"@id":"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/#primaryimage"},"thumbnailUrl":"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png","keywords":["basis data","database","erd","erd basis data","erd chen","erd crows foot","laragon","mysql","sql"],"articleSection":["Database","Lainnya"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/","url":"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/","name":"Entity Relationship Diagram (ERD) Basis Data - Episode 3 - Gurututorku","isPartOf":{"@id":"https:\/\/gurututorku.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/#primaryimage"},"image":{"@id":"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/#primaryimage"},"thumbnailUrl":"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png","datePublished":"2024-11-07T00:57:17+00:00","dateModified":"2024-11-07T02:08:35+00:00","breadcrumb":{"@id":"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/#primaryimage","url":"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png","contentUrl":"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/database.png","width":1000,"height":750},{"@type":"BreadcrumbList","@id":"https:\/\/gurututorku.com\/blog\/entity-relationship-diagram-erd-basis-data-episode-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/gurututorku.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Entity Relationship Diagram (ERD) Basis Data – Episode 3"}]},{"@type":"WebSite","@id":"https:\/\/gurututorku.com\/blog\/#website","url":"https:\/\/gurututorku.com\/blog\/","name":"Gurututorku - Learning today success tomorrow","description":"Kelas dan Kursus Programming, Design, Multimedia dan Tutorial IT lainnya.","publisher":{"@id":"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/gurututorku.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/6c85586545a9930343cd35e9bf4bd9a2","name":"gtadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/cropped-gurututorku-favicon.png","contentUrl":"https:\/\/gurututorku.com\/blog\/wp-content\/uploads\/2024\/11\/cropped-gurututorku-favicon.png","width":512,"height":512,"caption":"gtadmin"},"logo":{"@id":"https:\/\/gurututorku.com\/blog\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/gurututorku.com\/blog"],"url":"https:\/\/gurututorku.com\/blog\/author\/gtadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/posts\/911","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/comments?post=911"}],"version-history":[{"count":1,"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/posts\/911\/revisions"}],"predecessor-version":[{"id":912,"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/posts\/911\/revisions\/912"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/media\/905"}],"wp:attachment":[{"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/media?parent=911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/categories?post=911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gurututorku.com\/blog\/wp-json\/wp\/v2\/tags?post=911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}