{"id":2742,"date":"2022-05-06T06:20:40","date_gmt":"2022-05-06T06:20:40","guid":{"rendered":"https:\/\/sunaonako.my.id\/?p=2742"},"modified":"2022-05-09T06:23:06","modified_gmt":"2022-05-09T06:23:06","slug":"pengenalan-database-sql-server-membuat-tabel-relasi","status":"publish","type":"post","link":"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/","title":{"rendered":"Pengenalan Database SQL Server: Membuat Tabel Relasi"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Tutorial membuat database di Microsoft SQL Server Management Studio (MSSM). Bagi yang tidak tahu, Bahasa pemrograman yang digunakan adalah SQL yang merupakan tipe bahasa pemrograman yang digunakan untuk mengelola data pada sistem managemen database yang bersifat relasional. Di kesempatan ini, kita akan mempelajari pengenalan software SQL Server Management Studio dengan membuat database beserta relasi dan foreign key.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Diagram Tabel SQL <\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">kita akan mencoba membuat tabel dengan relasi seperti gambar di bawah ini.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"975\" height=\"397\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image.png\" alt=\"Create Diagram Table in MS SQL Server\" class=\"wp-image-2817\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image.png 975w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-300x122.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-768x313.png 768w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-360x147.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-545x222.png 545w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Silahkan buka sql management studio<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Secara default untuk konek ke server sql, format server name adalah nama_mac\\nama_servicesql. tergantung saat pertama kamu installasi microsoft sql management studio, nama_servicesql bisa kamu dapatkan melalui services management os.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"638\" height=\"384\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-37.png\" alt=\"How to get the server name of sql server to connect in SQL Server Management Studio\" class=\"wp-image-2752\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-37.png 638w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-37-300x181.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-37-360x217.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-37-545x328.png 545w\" sizes=\"(max-width: 638px) 100vw, 638px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Untuk mengetahui server name sql di windows cukup pada search bar ketik service, lalu klik menu &#8220;services&#8221;, kemudian cari SQL Server. Di dalam tanda kurung adalah nama server sql di windows kamu. Gunakan itu untuk koneksi ke SQL Server agar dapat terhubung ke studio.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"946\" height=\"239\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-38.png\" alt=\"cara mengetahui server name sql server\" class=\"wp-image-2753\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-38.png 946w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-38-300x76.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-38-768x194.png 768w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-38-360x91.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-38-545x138.png 545w\" sizes=\"(max-width: 946px) 100vw, 946px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"> Setelah berhasil koneksi, MSSM Studio akan meload dashboard, dengan tampilan awal berikut ini:<\/p>\n\n\n\n<div class=\"wp-block-image size-large\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"560\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-36-1024x560.png\" alt=\"Cara terhubung ke Micorosoft SQL Server Management Studio\" class=\"wp-image-2751\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-36-1024x560.png 1024w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-36-300x164.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-36-768x420.png 768w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-36-1536x839.png 1536w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-36-360x197.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-36-545x298.png 545w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-36-1600x874.png 1600w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-36.png 1916w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Membuat Database Di Microsoft SQL Server Management GUI<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Pada artikel ini akan fokus membuat database sampai tabel relasi secara visual di Microsoft SQL Server Management. Artinya, di artikel ini tidak membahas secara mendalam penggunaan script pemrograman dan lebih fokus ke GUI Microsoft SQL Server Management karena cara kerja scripting database di MS SQL itu sama seperti database relational pada umumnya.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pertama, untuk membuat koneksi database, arahkan ke folder database, klik kanan dan pilih New Database&#8230;<\/p>\n\n\n<div class=\"wp-block-image size-full\">\n<figure class=\"aligncenter\"><img decoding=\"async\" width=\"642\" height=\"461\" class=\"wp-image-2754 alignnone\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-39.png\" alt=\"\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-39.png 642w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-39-300x215.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-39-360x259.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/04\/image-39-545x391.png 545w\" sizes=\"(max-width: 642px) 100vw, 642px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Masukkan informasi terutama nama database<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"899\" height=\"805\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-1.png\" alt=\"Create Schema in SQL Server management Studio, membuat koneksi database di SQL Server Management Studio\" class=\"wp-image-2822\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-1.png 899w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-1-300x269.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-1-768x688.png 768w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-1-360x322.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-1-545x488.png 545w\" sizes=\"(max-width: 899px) 100vw, 899px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Berikutnya, Tutorial Membuat Tabel di Microsoft SQL Server Management Studio<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Untuk membuat tabel pada SQL Server Management, klik ikon + disebelah nama DB yang kamu buat, ini akan menampilkan <em>tree folders<\/em> yang ada di dalam database folder. Di sini ada Tables folder, klik kanan pada tables folder kemudian pilih new -&gt; table.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"688\" height=\"584\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-2.png\" alt=\"\" class=\"wp-image-2823\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-2.png 688w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-2-300x255.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-2-360x306.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-2-545x463.png 545w\" sizes=\"(max-width: 688px) 100vw, 688px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Ini adalah tabel untuk informasi Customer, sql naming convention untuk tabel seharusnya adalah singular dan CamelCase. <em>But<\/em>, Kali ini kita tidak akan belajar naming convention untuk Microsoft SQL. Selain karena opinion based, kita kali ini hanya fokus belajar membuat tabel pada sql. Kalau kamu ingin belajar naming convention SQL, bisa lihat salah satu contoh standar yang terkenal di <a href=\"https:\/\/github.com\/Microsoft\/sql-server-samples\/releases\/tag\/adventureworks\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">github ini<\/a>.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"733\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-3-1024x733.png\" alt=\"\" class=\"wp-image-2824\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-3-1024x733.png 1024w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-3-300x215.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-3-768x550.png 768w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-3-360x258.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-3-545x390.png 545w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-3.png 1209w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Mengisi baris dan kolom pada tabel di MS SQL Server Management Studio<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Coba lihat tampilan tabel pada Microsoft SQL.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"733\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-4-1024x733.png\" alt=\"\" class=\"wp-image-2825\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-4-1024x733.png 1024w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-4-300x215.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-4-768x550.png 768w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-4-360x258.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-4-545x390.png 545w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-4.png 1209w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Cara mengisi tabel MS SQL hampir persis seperti database relational pada umumnya contoh MySQL. Untuk tiap baris terdiri dari 3 kolom. Column name, Data Type dan Allow Nulls. Perhatikan tabel diatas mempunyai field name ID yang mempunyai tipe data int dengan properties non null (kalau allow null <strong>tidak <\/strong>kamu centang, maka field tersebut harus diisi \/ wajib mempunyai nilai), mengapa ID non null? Karena itu adalah penanda record alias sebagai <em>primary key<\/em>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Semisal kamu ingin membuat atribut <strong>BorrowerName <\/strong>dengan tipe data <strong>nvarchar <\/strong>(untuk teks panjang), kamu dapat klik field data type nanti akan muncul list dropdown tipe data yang ingin kamu terapkan pada atribut tersebut. Misal, karena berbentuk teks panjang aku pilih nvarchar(50). Seperti gambar ini.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"762\" height=\"378\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-5.png\" alt=\"Membuat tabel secara visual sql server\" class=\"wp-image-2826\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-5.png 762w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-5-300x149.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-5-360x180.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-5-545x270.png 545w\" sizes=\"(max-width: 762px) 100vw, 762px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Selain itu, kamu bisa merubah nilai maksimum nvarchar, misal dapat menerima teks hingga 150 karakter. Arahkan kursor ke teks nvarchar(50) klik lalu rubah teks 50 menjadi 150.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"695\" height=\"205\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-6.png\" alt=\"\" class=\"wp-image-2827\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-6.png 695w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-6-300x88.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-6-360x106.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-6-545x161.png 545w\" sizes=\"(max-width: 695px) 100vw, 695px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Mudah bukan? Sekarang challenge buat kamu, coba buat field data lainnya dengan informasi seperti ini:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Column name DateBorrowed format datetime<\/li><li>Column name DateReturned format datetime<\/li><li>Column name Cost untuk menyimpan harga maka adalah bilangan bulat.<\/li><\/ol>\n\n\n\n<!--nextpage-->\n\n\n\n<p class=\"wp-block-paragraph\">Jika sudah selesai silahkan bandingkan dengan tabel dibawah:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"625\" height=\"238\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-7.png\" alt=\"\" class=\"wp-image-2828\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-7.png 625w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-7-300x114.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-7-360x137.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-7-545x208.png 545w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Seharusnya lewat gambar kamu sudah paham <em>yep<\/em>, mungkin yang membingungkan adalah <strong>decimal(p,s)<\/strong>, parameter p artinya precission yaitu berapa banyak jumlah digit keseluruhan angka sedangkan s adalah skala yaitu jumlah bilangan dibelakang \u201ckoma\u201d, misal decimal(7,5) maka akan ada 2 angka di kiri koma dan 5 angka dikanan koma, contoh: 25,123.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Cara Membuat primary key pada tabel di MS SQL Database secara visual \/ GUI.<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Untuk membuat primary key tabel, cukup klik field mana yang akan dijadikan primary key. Misal ID, cukup klik kanan pada ID dan akan muncul banyak pilihan opsi. Pilih set primary key.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"408\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-8-1024x408.png\" alt=\"\" class=\"wp-image-2829\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-8-1024x408.png 1024w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-8-300x120.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-8-768x306.png 768w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-8-360x144.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-8-545x217.png 545w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-8.png 1078w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Untuk mengetahui primary key yang ada pada tabel. Kamu dapat lihat di kolom yang ada golden key maka itu adalah primary key tabel.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"614\" height=\"220\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-10.png\" alt=\"Micrososft SQL Database apa itu sintaks decimal()\" class=\"wp-image-2831\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-10.png 614w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-10-300x107.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-10-360x129.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-10-545x195.png 545w\" sizes=\"(max-width: 614px) 100vw, 614px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Membuat atribut data terisi otomatis, membuat increment pada field di tabel SQL<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Seperti kita tahu, umumnya primary key seperti ID akan otomatis terisi dengan kode unik yang membedakan satu record dengan record lainnya (misal mahasiswa {yang terdiri dari NIM} Budi pasti mempunyai nomor induk pelajar yang berbeda dengan mahasiswa Ruslan). Ada cara untuk membuat ID unik dengan membuat setiap record yang dibuat akan otomatis ID-nya incremental, yaitu pada column properties yang berada di bawah Workspace Desain Tabel kalian cari Identity Specification.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"355\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-11-1024x355.png\" alt=\"Cara membuat primary key di SQL Server Management Studio. MS SQL primary key yang dapat mengisi sendiri melalui increment attribut.\" class=\"wp-image-2832\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-11-1024x355.png 1024w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-11-300x104.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-11-768x266.png 768w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-11-360x125.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-11-545x189.png 545w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-11.png 1198w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Klik &gt; di samping identity specification akan menampilkan opsi dropdown.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"705\" height=\"137\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-12.png\" alt=\"Create primary key that autofills and increment itself in Microsoft SQL Server Management Studio\" class=\"wp-image-2833\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-12.png 705w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-12-300x58.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-12-360x70.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-12-545x106.png 545w\" sizes=\"(max-width: 705px) 100vw, 705px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Kemudian pada kotak disamping is Identity, kamu rubah ke yes dan set identity increment ke 1, otomatis setiap record yang dibuat akan punya ID berbeda yang incremental berdasarkan urutan record tersebut dibuat. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Menyimpan tabel di MS SQL Server Management Studio<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Untuk save tabel di MSSM Studio, klik ctrl + s, masukkan nama misal Customer.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"522\" height=\"277\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-13.png\" alt=\"\" class=\"wp-image-2834\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-13.png 522w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-13-300x159.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-13-360x191.png 360w\" sizes=\"(max-width: 522px) 100vw, 522px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Menambahkan tabel di MSSM Studio<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Kita akan membuat tabel lain yaitu Product, caranya seperti membuat tabel diatas, buat fieldnya agar seperti gambar di bawah:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"692\" height=\"222\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-14.png\" alt=\"Input attribut in table sql server\" class=\"wp-image-2835\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-14.png 692w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-14-300x96.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-14-360x115.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-14-545x175.png 545w\" sizes=\"(max-width: 692px) 100vw, 692px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Set ID menjadi primary key seperti cara sebelumnya, klik kanan pada field ID, lalu pilih set primary key. Lalu sambil seleksi field ID, pada column properties atur increment agar field dapat mengisi data otomatis.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"854\" height=\"657\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-15.png\" alt=\"Langkah demi langkah membuat foreign key secara visual di microsoft sql server management studio\" class=\"wp-image-2836\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-15.png 854w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-15-300x231.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-15-768x591.png 768w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-15-360x277.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-15-545x419.png 545w\" sizes=\"(max-width: 854px) 100vw, 854px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Kemudian simpan tabel sebagai Product, bisa dengan menekan ctrl + s.<\/p>\n\n\n\n<!--nextpage-->\n\n\n\n<h2 class=\"wp-block-heading\">Membuat Relasi Tabel Di SQL Server Studio Secara Visual, Membuat foreign key di Tabel dengan GUI MSSM Studio<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Kali ini kita akan menghubungkan tabel dengan tabel alias table relationship di Microsoft SQL Server Management Studio.  <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Anggap setiap customer meminjam minimal satu produk, maka diperlukan koneksi antar tabel. Sekarang kita akan menambahkan attribut productid pada tabel customer, productid ini akan menjadi foreign key Product yang berarti attribut yang di simpan di tabel Customer akan mereferensikan ID pada tabel Product.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kita akan memperbarui tabel Customer, untuk update tabel dan mengedit ulang field table, di sidebar Object Explorer, Klik kanan pada tabel Customer,<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"461\" height=\"215\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-16.png\" alt=\"How to update table (cara memperbarui tabel dengan attribut \/ field baru) MS SQL Management Studio\" class=\"wp-image-2837\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-16.png 461w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-16-300x140.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-16-360x168.png 360w\" sizes=\"(max-width: 461px) 100vw, 461px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Pilih design<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Setelah itu tambahkan productid di field baru dengan data type int<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"643\" height=\"268\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-17.png\" alt=\"Cara  update tabel di SQL Server dan menghubungkan dua tabel menggunakan foreign key\" class=\"wp-image-2838\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-17.png 643w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-17-300x125.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-17-360x150.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-17-545x227.png 545w\" sizes=\"(max-width: 643px) 100vw, 643px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Klik kanan pada tabel, lalu pilih relationships<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"497\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-18-1024x497.png\" alt=\"How to add foreign key to a table sql server management studio visually (no scripting)\" class=\"wp-image-2839\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-18-1024x497.png 1024w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-18-300x145.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-18-768x372.png 768w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-18-360x175.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-18-545x264.png 545w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-18.png 1361w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Akan muncul popup, klik Add, akan muncul FK_Customer_dsb pada kiri sidebar, klik teks tersebut, akan muncul list tabs di kanan. Pada tab General, klik icon &gt; pada<strong> tables and Column Spec<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Klik Table and Columns Spec, akan muncul kotak \u2026<br><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"732\" height=\"522\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-19.png\" alt=\"\" class=\"wp-image-2840\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-19.png 732w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-19-300x214.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-19-360x257.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-19-545x389.png 545w\" sizes=\"(max-width: 732px) 100vw, 732px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"697\" height=\"596\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-20.png\" alt=\"The Microsoft SQL Server Management guide to table relationship using foreign key to primary key\" class=\"wp-image-2843\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-20.png 697w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-20-300x257.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-20-360x308.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-20-545x466.png 545w\" sizes=\"(max-width: 697px) 100vw, 697px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Maksud dari pengaturan ini adalah, dalam Tabel Customer kita akan mempunyai referensi tabel Product melalui primary key ID Product. ID product ini terhubung ke Tabel Customer melalui field ProductID yang kita buat sebelumnya. Klik Ok untuk menyimpan. Secara otomatis nama relationship-nya akan dibuat berdasarkan <em>logic <\/em>pengaturanmu oleh SQL Server Studio.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Menampilkan Desain Tabel pada Database menggunakan Microsoft SQL Server Management Studio<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Setelah membuat semua tabel dan relasi tabel diatas, kita perlu mengetahui diagram desain relasi antar tabel agar dapat memastikan bahwa tabel yang kita buat tadi sudah benar desainnya, salah satunya dengan generate Diagram, SQL punya cara untuk.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pada folder koneksi databasemu akan ada tree folder Database Diagram klik kanan folder tersebut dan pilih create database diagram<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"700\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-21-1024x700.png\" alt=\"Langkah membuat diagram tabel Microsoft SQL Server\" class=\"wp-image-2846\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-21-1024x700.png 1024w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-21-300x205.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-21-768x525.png 768w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-21-360x246.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-21-545x372.png 545w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-21.png 1029w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Tahan ctrl dan klik kiri pada tabel apa saja yang akan kamu masukkan dalam diagram<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"490\" src=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-23-1024x490.png\" alt=\"Cara menampilkan tabel relasi di Microsof SQL Server Management Studio\" class=\"wp-image-2848\" srcset=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-23-1024x490.png 1024w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-23-300x144.png 300w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-23-768x368.png 768w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-23-360x172.png 360w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-23-545x261.png 545w, https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/image-23.png 1209w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Selesai \ud83d\ude00<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Jangan lupa untuk follow akun sosial media nakotek dan tetap terus update tips dan tutorial microsoft SQL Server, di <a href=\"https:\/\/sunaonako.my.id\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"nakotek\">nako teknologi<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tutorial membuat database di Microsoft SQL Server Management Studio (MSSM). Bagi yang tidak tahu, Bahasa pemrograman yang digunakan adalah SQL yang merupakan tipe bahasa pemrograman yang digunakan untuk mengelola data pada sistem managemen database yang bersifat relasional. Di kesempatan ini, kita akan mempelajari pengenalan software SQL Server Management Studio dengan membuat database beserta relasi dan&#8230;<\/p>\n","protected":false},"author":2,"featured_media":2849,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[251,248],"tags":[613,616,612],"class_list":["post-2742","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-backend","category-web","tag-database","tag-ms-sql","tag-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.8 (Yoast SEO v23.8) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Microsoft SQL Server Management Studio, Membuat Tabel Relasi<\/title>\n<meta name=\"description\" content=\"Tutorial Microsoft SQL Server Management Studio Membuat Database. Langkah Membuat tabel relasi menghubungkan tabel dengan foreign key visual tanpa scripting.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/\" \/>\n<link rel=\"next\" href=\"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pengenalan Database SQL Server: Membuat Tabel Relasi\" \/>\n<meta property=\"og:description\" content=\"Tutorial Microsoft SQL Server Management Studio Membuat Database. Langkah Membuat tabel relasi menghubungkan tabel dengan foreign key visual tanpa scripting.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/\" \/>\n<meta property=\"og:site_name\" content=\"Hilarious Developer School\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-06T06:20:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-09T06:23:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/Beginner-SQL-Server.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"nakomin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"nakomin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/\"},\"author\":{\"name\":\"nakomin\",\"@id\":\"https:\/\/sunaonako.my.id\/#\/schema\/person\/e35d0cb9128a86b66ec2ba6abacadd5a\"},\"headline\":\"Pengenalan Database SQL Server: Membuat Tabel Relasi\",\"datePublished\":\"2022-05-06T06:20:40+00:00\",\"dateModified\":\"2022-05-09T06:23:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/\"},\"wordCount\":1208,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sunaonako.my.id\/#\/schema\/person\/e35d0cb9128a86b66ec2ba6abacadd5a\"},\"image\":{\"@id\":\"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/Beginner-SQL-Server.png\",\"keywords\":[\"Database\",\"MS SQL\",\"SQL Server\"],\"articleSection\":[\"Back End\",\"Web\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/\",\"url\":\"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/\",\"name\":\"Microsoft SQL Server Management Studio, Membuat Tabel Relasi\",\"isPartOf\":{\"@id\":\"https:\/\/sunaonako.my.id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/Beginner-SQL-Server.png\",\"datePublished\":\"2022-05-06T06:20:40+00:00\",\"dateModified\":\"2022-05-09T06:23:06+00:00\",\"description\":\"Tutorial Microsoft SQL Server Management Studio Membuat Database. Langkah Membuat tabel relasi menghubungkan tabel dengan foreign key visual tanpa scripting.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/#primaryimage\",\"url\":\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/Beginner-SQL-Server.png\",\"contentUrl\":\"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/Beginner-SQL-Server.png\",\"width\":1920,\"height\":1080,\"caption\":\"Tutorial SQL Server untuk pemula, membuat Database hingga tabel relasi mudah\"},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sunaonako.my.id\/#website\",\"url\":\"https:\/\/sunaonako.my.id\/\",\"name\":\"Hilarious Developer School\",\"description\":\"Catatan Developer tentang Kurikulum Dunia Modern\",\"publisher\":{\"@id\":\"https:\/\/sunaonako.my.id\/#\/schema\/person\/e35d0cb9128a86b66ec2ba6abacadd5a\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sunaonako.my.id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/sunaonako.my.id\/#\/schema\/person\/e35d0cb9128a86b66ec2ba6abacadd5a\",\"name\":\"nakomin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sunaonako.my.id\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/cdn.sunaonako.my.id\/aruuploads\/2021\/07\/Minimalist-Letter-Initial-Logo.png\",\"contentUrl\":\"https:\/\/cdn.sunaonako.my.id\/aruuploads\/2021\/07\/Minimalist-Letter-Initial-Logo.png\",\"width\":\"250\",\"height\":\"250\",\"caption\":\"nakomin\"},\"logo\":{\"@id\":\"https:\/\/sunaonako.my.id\/#\/schema\/person\/image\/\"},\"description\":\"Believe at the heart of BNRS Here you will find content about developers needs whether it\u2019s coding tutorials or the lifestyle of employee in the IT circle, understanding of the realm of ui\/ux and futuristic tech for free in one place. Don\u2019t forget to follow the nakotek socials to give the author enthusiasm in pioneering this website. #wahahaforever\",\"sameAs\":[\"https:\/\/sunaonako.my.id\"],\"url\":\"https:\/\/sunaonako.my.id\/tomodachi\/nakomin\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Microsoft SQL Server Management Studio, Membuat Tabel Relasi","description":"Tutorial Microsoft SQL Server Management Studio Membuat Database. Langkah Membuat tabel relasi menghubungkan tabel dengan foreign key visual tanpa scripting.","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:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/","next":"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/2\/","og_locale":"en_US","og_type":"article","og_title":"Pengenalan Database SQL Server: Membuat Tabel Relasi","og_description":"Tutorial Microsoft SQL Server Management Studio Membuat Database. Langkah Membuat tabel relasi menghubungkan tabel dengan foreign key visual tanpa scripting.","og_url":"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/","og_site_name":"Hilarious Developer School","article_published_time":"2022-05-06T06:20:40+00:00","article_modified_time":"2022-05-09T06:23:06+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/Beginner-SQL-Server.png","type":"image\/png"}],"author":"nakomin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"nakomin","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/#article","isPartOf":{"@id":"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/"},"author":{"name":"nakomin","@id":"https:\/\/sunaonako.my.id\/#\/schema\/person\/e35d0cb9128a86b66ec2ba6abacadd5a"},"headline":"Pengenalan Database SQL Server: Membuat Tabel Relasi","datePublished":"2022-05-06T06:20:40+00:00","dateModified":"2022-05-09T06:23:06+00:00","mainEntityOfPage":{"@id":"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/"},"wordCount":1208,"commentCount":0,"publisher":{"@id":"https:\/\/sunaonako.my.id\/#\/schema\/person\/e35d0cb9128a86b66ec2ba6abacadd5a"},"image":{"@id":"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/#primaryimage"},"thumbnailUrl":"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/Beginner-SQL-Server.png","keywords":["Database","MS SQL","SQL Server"],"articleSection":["Back End","Web"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/","url":"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/","name":"Microsoft SQL Server Management Studio, Membuat Tabel Relasi","isPartOf":{"@id":"https:\/\/sunaonako.my.id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/#primaryimage"},"image":{"@id":"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/#primaryimage"},"thumbnailUrl":"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/Beginner-SQL-Server.png","datePublished":"2022-05-06T06:20:40+00:00","dateModified":"2022-05-09T06:23:06+00:00","description":"Tutorial Microsoft SQL Server Management Studio Membuat Database. Langkah Membuat tabel relasi menghubungkan tabel dengan foreign key visual tanpa scripting.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sunaonako.my.id\/blog\/pengenalan-database-sql-server-membuat-tabel-relasi\/#primaryimage","url":"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/Beginner-SQL-Server.png","contentUrl":"https:\/\/sunaonako.my.id\/aruuploads\/2022\/05\/Beginner-SQL-Server.png","width":1920,"height":1080,"caption":"Tutorial SQL Server untuk pemula, membuat Database hingga tabel relasi mudah"},{"@type":"WebSite","@id":"https:\/\/sunaonako.my.id\/#website","url":"https:\/\/sunaonako.my.id\/","name":"Hilarious Developer School","description":"Catatan Developer tentang Kurikulum Dunia Modern","publisher":{"@id":"https:\/\/sunaonako.my.id\/#\/schema\/person\/e35d0cb9128a86b66ec2ba6abacadd5a"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sunaonako.my.id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/sunaonako.my.id\/#\/schema\/person\/e35d0cb9128a86b66ec2ba6abacadd5a","name":"nakomin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sunaonako.my.id\/#\/schema\/person\/image\/","url":"https:\/\/cdn.sunaonako.my.id\/aruuploads\/2021\/07\/Minimalist-Letter-Initial-Logo.png","contentUrl":"https:\/\/cdn.sunaonako.my.id\/aruuploads\/2021\/07\/Minimalist-Letter-Initial-Logo.png","width":"250","height":"250","caption":"nakomin"},"logo":{"@id":"https:\/\/sunaonako.my.id\/#\/schema\/person\/image\/"},"description":"Believe at the heart of BNRS Here you will find content about developers needs whether it\u2019s coding tutorials or the lifestyle of employee in the IT circle, understanding of the realm of ui\/ux and futuristic tech for free in one place. Don\u2019t forget to follow the nakotek socials to give the author enthusiasm in pioneering this website. #wahahaforever","sameAs":["https:\/\/sunaonako.my.id"],"url":"https:\/\/sunaonako.my.id\/tomodachi\/nakomin\/"}]}},"_links":{"self":[{"href":"https:\/\/sunaonako.my.id\/apps-api\/wp\/v2\/posts\/2742","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sunaonako.my.id\/apps-api\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sunaonako.my.id\/apps-api\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sunaonako.my.id\/apps-api\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sunaonako.my.id\/apps-api\/wp\/v2\/comments?post=2742"}],"version-history":[{"count":0,"href":"https:\/\/sunaonako.my.id\/apps-api\/wp\/v2\/posts\/2742\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunaonako.my.id\/apps-api\/wp\/v2\/media\/2849"}],"wp:attachment":[{"href":"https:\/\/sunaonako.my.id\/apps-api\/wp\/v2\/media?parent=2742"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunaonako.my.id\/apps-api\/wp\/v2\/categories?post=2742"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunaonako.my.id\/apps-api\/wp\/v2\/tags?post=2742"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}