{"id":10523,"date":"2022-05-25T16:26:55","date_gmt":"2022-05-25T09:26:55","guid":{"rendered":"https:\/\/binus.ac.id\/malang\/?p=10523"},"modified":"2022-05-25T16:26:55","modified_gmt":"2022-05-25T09:26:55","slug":"relational-dalam-database","status":"publish","type":"post","link":"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/","title":{"rendered":"Relational dalam Database"},"content":{"rendered":"

Relational adalah hubungan antara entity. Semisal pada contoh di atas <\/span>entity manusia mempunyai hubungan dengan entity alamat yaitu\u201dtinggal di\u201d. Di <\/span>dalam<\/span> merancang<\/span> database<\/span> hendaknya<\/span> seluruh<\/span> entity<\/span> yang<\/span> ada<\/span> mempunyai <\/span>hubungan dengan entity ya<\/span>ng lain, minimal satu. Jika ada entity dalam database <\/span>yang tidak mempunyai hubungan dengan satupun entity yang lain, maka akan <\/span>timbul kesalahan dalam desain. Biasanya entity yang tidak berhubungan akan <\/span>dihilangkan.<\/span><\/p>\n

Macam relasi ada 4, antara lain :<\/span><\/p>\n

    \n
  1. One to<\/span> <\/strong>one<\/strong> : Sebuah entitas A yang berpasangan dengan tepat satuentitas <\/span>B. Demikian pula entitas B juga berpasangan tepat satu dengan entitas A. <\/span>Contoh entitas mahasiswa yang berelasi denganentitas skripsi secara one <\/span>to one.<\/span><\/li>\n
  2. One to many<\/strong> : Sebuah entitas A yang b<\/span>erpasangan secara banyak (nolatau <\/span>lebih) dengan entitas di dalam B. Sedangkan entitas B hanyaberpasangan <\/span>dengan tepat satu entitas di dalam A. Contoh : entitasmahasiswa yang <\/span>berelasi dengan entitas dosen dalam hubungandosen pembimbing. Relasi yang terjadi secara one to many. Karenaseorang mahasiswa hanya memiliki 1 dosen pembimbing. Sedangkanseorang dosen bisa jadi memiliki mahasiswa bimbingan lebih dari satu.<\/span><\/li>\n
  3. Many to one<\/strong> : Sebuah entitas A yang berpasangan dengan tepat satuentitas di dalam B. Sedangkan entitas B dapat berpasangan secarabanyak (nol atau lebih) dengan entitas di dalam A. (sama seperti oneto many hanya dibalik pengertiannya)<\/span><\/li>\n
  4. Many to many<\/strong> : Sebuah entitas A yang berpasangan secara banyak(nol atau lebih) dengan entitas di dalam B. Dan entitas B juga dapatberpasangan secara banyak (nol atau lebih) dengan entitas di dalam A. Contoh : entitas mahasiswa yang berelasi dengan entitas matakuliah dalam hubungan KRS. Relasi tersebut adalah many to many. Karena seorang mahasiswa dapat mengambil banyak matakuliah. Sedangkan satu mata kuliah bisa jadi diambil oleh beberapa mahasiswa.
    \n<\/span><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    Relational adalah hubungan antara entity. Semisal pada contoh di atas entity manusia mempunyai hubungan dengan entity alamat yaitu\u201dtinggal di\u201d. Di dalam merancang database hendaknya seluruh entity yang ada mempunyai hubungan dengan entity yang lain, minimal satu. Jika ada entity dalam database yang tidak mempunyai hubungan dengan satupun entity yang lain, maka akan timbul kesalahan dalam […]<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[128],"tags":[],"class_list":["post-10523","post","type-post","status-publish","format-standard","hentry","category-computer-science"],"yoast_head":"\nRelational dalam Database | BINUS UNIVERSITY MALANG | Pilihan Universitas Terbaik di Malang<\/title>\n<meta name=\"description\" content=\"BINUS University Malang Merupakan Universitas Terbaik di Malang dengan Program Computer Science, Entrepreneurship Bussiness Creation, Computer Science, Interior Design, Communication, Public Relations, Visual Communication Design.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Relational dalam Database | BINUS UNIVERSITY MALANG | Pilihan Universitas Terbaik di Malang\" \/>\n<meta property=\"og:description\" content=\"BINUS University Malang Merupakan Universitas Terbaik di Malang dengan Program Computer Science, Entrepreneurship Bussiness Creation, Computer Science, Interior Design, Communication, Public Relations, Visual Communication Design.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/\" \/>\n<meta property=\"og:site_name\" content=\"BINUS UNIVERSITY MALANG | Pilihan Universitas Terbaik di Malang\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-25T09:26:55+00:00\" \/>\n<meta name=\"author\" content=\"informatics\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"informatics\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/\"},\"author\":{\"name\":\"informatics\",\"@id\":\"https:\/\/binus.ac.id\/malang\/#\/schema\/person\/82104d3e6f72d20991a92c10c2e7b183\"},\"headline\":\"Relational dalam Database\",\"datePublished\":\"2022-05-25T09:26:55+00:00\",\"dateModified\":\"2022-05-25T09:26:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/\"},\"wordCount\":271,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/binus.ac.id\/malang\/#organization\"},\"articleSection\":[\"Computer Science\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/\",\"url\":\"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/\",\"name\":\"Relational dalam Database | BINUS UNIVERSITY MALANG | Pilihan Universitas Terbaik di Malang\",\"isPartOf\":{\"@id\":\"https:\/\/binus.ac.id\/malang\/#website\"},\"datePublished\":\"2022-05-25T09:26:55+00:00\",\"dateModified\":\"2022-05-25T09:26:55+00:00\",\"description\":\"BINUS University Malang Merupakan Universitas Terbaik di Malang dengan Program Computer Science, Entrepreneurship Bussiness Creation, Computer Science, Interior Design, Communication, Public Relations, Visual Communication Design.\",\"breadcrumb\":{\"@id\":\"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/binus.ac.id\/malang\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Relational dalam Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/binus.ac.id\/malang\/#website\",\"url\":\"https:\/\/binus.ac.id\/malang\/\",\"name\":\"BINUS UNIVERSITY MALANG | Pilihan Universitas Terbaik di Malang\",\"description\":\"BINUS UNIVERSITY\",\"publisher\":{\"@id\":\"https:\/\/binus.ac.id\/malang\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/binus.ac.id\/malang\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/binus.ac.id\/malang\/#organization\",\"name\":\"BINUS UNIVERSITY\",\"url\":\"https:\/\/binus.ac.id\/malang\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/binus.ac.id\/malang\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/binus.ac.id\/malang\/wp-content\/uploads\/2019\/07\/site-logo.png\",\"contentUrl\":\"https:\/\/binus.ac.id\/malang\/wp-content\/uploads\/2019\/07\/site-logo.png\",\"width\":140,\"height\":84,\"caption\":\"BINUS UNIVERSITY\"},\"image\":{\"@id\":\"https:\/\/binus.ac.id\/malang\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/binus.ac.id\/malang\/#\/schema\/person\/82104d3e6f72d20991a92c10c2e7b183\",\"name\":\"informatics\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/binus.ac.id\/malang\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/42be0c661cdbdcdd941bf5610126b17508883f5bb40e38bd6242084edb497351?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/42be0c661cdbdcdd941bf5610126b17508883f5bb40e38bd6242084edb497351?s=96&d=mm&r=g\",\"caption\":\"informatics\"},\"url\":\"https:\/\/binus.ac.id\/malang\/author\/informatics\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Relational dalam Database | BINUS UNIVERSITY MALANG | Pilihan Universitas Terbaik di Malang","description":"BINUS University Malang Merupakan Universitas Terbaik di Malang dengan Program Computer Science, Entrepreneurship Bussiness Creation, Computer Science, Interior Design, Communication, Public Relations, Visual Communication Design.","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:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/","og_locale":"en_US","og_type":"article","og_title":"Relational dalam Database | BINUS UNIVERSITY MALANG | Pilihan Universitas Terbaik di Malang","og_description":"BINUS University Malang Merupakan Universitas Terbaik di Malang dengan Program Computer Science, Entrepreneurship Bussiness Creation, Computer Science, Interior Design, Communication, Public Relations, Visual Communication Design.","og_url":"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/","og_site_name":"BINUS UNIVERSITY MALANG | Pilihan Universitas Terbaik di Malang","article_published_time":"2022-05-25T09:26:55+00:00","author":"informatics","twitter_card":"summary_large_image","twitter_misc":{"Written by":"informatics","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/#article","isPartOf":{"@id":"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/"},"author":{"name":"informatics","@id":"https:\/\/binus.ac.id\/malang\/#\/schema\/person\/82104d3e6f72d20991a92c10c2e7b183"},"headline":"Relational dalam Database","datePublished":"2022-05-25T09:26:55+00:00","dateModified":"2022-05-25T09:26:55+00:00","mainEntityOfPage":{"@id":"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/"},"wordCount":271,"commentCount":0,"publisher":{"@id":"https:\/\/binus.ac.id\/malang\/#organization"},"articleSection":["Computer Science"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/","url":"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/","name":"Relational dalam Database | BINUS UNIVERSITY MALANG | Pilihan Universitas Terbaik di Malang","isPartOf":{"@id":"https:\/\/binus.ac.id\/malang\/#website"},"datePublished":"2022-05-25T09:26:55+00:00","dateModified":"2022-05-25T09:26:55+00:00","description":"BINUS University Malang Merupakan Universitas Terbaik di Malang dengan Program Computer Science, Entrepreneurship Bussiness Creation, Computer Science, Interior Design, Communication, Public Relations, Visual Communication Design.","breadcrumb":{"@id":"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/binus.ac.id\/malang\/2022\/05\/relational-dalam-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/binus.ac.id\/malang\/"},{"@type":"ListItem","position":2,"name":"Relational dalam Database"}]},{"@type":"WebSite","@id":"https:\/\/binus.ac.id\/malang\/#website","url":"https:\/\/binus.ac.id\/malang\/","name":"BINUS UNIVERSITY MALANG | Pilihan Universitas Terbaik di Malang","description":"BINUS UNIVERSITY","publisher":{"@id":"https:\/\/binus.ac.id\/malang\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/binus.ac.id\/malang\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/binus.ac.id\/malang\/#organization","name":"BINUS UNIVERSITY","url":"https:\/\/binus.ac.id\/malang\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/binus.ac.id\/malang\/#\/schema\/logo\/image\/","url":"https:\/\/binus.ac.id\/malang\/wp-content\/uploads\/2019\/07\/site-logo.png","contentUrl":"https:\/\/binus.ac.id\/malang\/wp-content\/uploads\/2019\/07\/site-logo.png","width":140,"height":84,"caption":"BINUS UNIVERSITY"},"image":{"@id":"https:\/\/binus.ac.id\/malang\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/binus.ac.id\/malang\/#\/schema\/person\/82104d3e6f72d20991a92c10c2e7b183","name":"informatics","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/binus.ac.id\/malang\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/42be0c661cdbdcdd941bf5610126b17508883f5bb40e38bd6242084edb497351?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/42be0c661cdbdcdd941bf5610126b17508883f5bb40e38bd6242084edb497351?s=96&d=mm&r=g","caption":"informatics"},"url":"https:\/\/binus.ac.id\/malang\/author\/informatics\/"}]}},"_links":{"self":[{"href":"https:\/\/binus.ac.id\/malang\/wp-json\/wp\/v2\/posts\/10523","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/binus.ac.id\/malang\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/binus.ac.id\/malang\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/binus.ac.id\/malang\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/binus.ac.id\/malang\/wp-json\/wp\/v2\/comments?post=10523"}],"version-history":[{"count":1,"href":"https:\/\/binus.ac.id\/malang\/wp-json\/wp\/v2\/posts\/10523\/revisions"}],"predecessor-version":[{"id":10524,"href":"https:\/\/binus.ac.id\/malang\/wp-json\/wp\/v2\/posts\/10523\/revisions\/10524"}],"wp:attachment":[{"href":"https:\/\/binus.ac.id\/malang\/wp-json\/wp\/v2\/media?parent=10523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/binus.ac.id\/malang\/wp-json\/wp\/v2\/categories?post=10523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/binus.ac.id\/malang\/wp-json\/wp\/v2\/tags?post=10523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}