Langkah - Langkah Pembuatan ERD di Microsoft Visio
ERD (Entity-Relationship Diagram)dapat dibentuk dengan menggunakan Microsoft Visio.Berikut adalah langkah-langkah pembuatan ERD dengan menggunakan Microsoft Visio:
1.Buka Microsoft Visio
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwN2bs5V8C-XzuAeOLjuk4mk9J2UIuRa9n2n1hun_wu43JZNyFHIwZZz4MaYCveewN65fwXIJhxAUy87svGhc1lpFtfPz0L3iajrAg3l2FANnDTC2gmiulwiDfkOpv78h5yFDpwWoWozQ/w514-h289/1.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnqyLy5DmZMJAP5FxKtX9A8meBoBIMOxrsFPK-iWfLdOCfDP_cXTv6bRZToRYW8oIsuPKVTZFML2ly3naV_1aPQCS_8CnKaxGNsLs3GvulIWUTyItTm0GmiLx2NnFNgjjigYUiiBNuivo/w509-h288/2.png)
3.Pilih Crow’s Foot Database Notation
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3nwoWBJaosOX08d0xPSrfuzvS7CSHE642fuKBt4z9h3nPLV8EzWejtqCv0hFrH7ePuZsOczQ66sq3B_7mx7_KJtW25aHN6SHzFalcd8RlMJiRih27e5hrOzZO4G6yXgwl4iiB15vtM2k/w496-h276/3.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVKuYoUWPJOpQ_nzRrG7euqWtA601olCqEPr4cPedBcahaYtOQZ2mBDo2-TqjsUsC5TcjsYlQAUhMXBsURRspQYeGOVEDoTFmJEYQpBdld48KS7BR55NQAwbuLAmxWps1qk3zQqoqMZiU/w488-h274/4.png)
5.Pada bagian kiri ada beberapa shapes yang bisa digunakan yaitu Entity, Primary Key Atribute, Primary Key Separator, Attribute, dan Relationship
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOR9gyNNhr6D9HBcMJeb_A_1k5sUviPKObOPmBUIelq0VobQirgNHMuXuJJqybEYUnC4NuNp-jEJMmCuvVYdXY3_i55jSDFm6CNfZJM3F1YCe6305LlpMU7Y4HCnnPeMR7lk59I3kVVEc/w497-h283/5.png)
6.Klik dan drag Entity ke bagian tengah
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvfJH7PFACz_Deei_ZYtjz330MuxPcrmD-xKL7EW5SZNuNxW4TbJNAS4UO-6BLhqxoj6rCf_j_r62ypvIBHFB574vx1LsSRX3UmWt9V3oJoJf6j1n_ek_4oKpsTkQrU6dBbVB0_RGoRvo/w496-h282/6.png)
7.Tampilan setelah Entity dimasukkan
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-oBAYcuQ9RKF_S7l6JeF3OILg7-_awc_h1oKye3onEewfS1kNaOJQc0RZkZ2aqLTMSMTJiQHsLaknWapR8PZJ-sqBftMpGCSeLwaEC8TUHcvA1bmKFeBPkcRIuItOAIGq691zgHulsq8/w473-h269/7.png)
8.Isikan bagian Entity Name dan attribute name
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBh05kGm9riL97sVcresujAVIW46pXxnbMVhd_MwZGvK4BC7Asp-_R_Fdt-S_p7t0yd-T0j8QNIpLUxb7-ywCXRI-RJ6ShtOBuOe34wbT62oINz3ru7geWQxJKC_le7HcwtUCeqwPJd0w/w500-h284/8.png)
9.Tampilan sesudah diisi
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4dvgCdb0EwmIq7Q6m-23Bmf0gMia29Cw9SgKw6LCh-wNRBDO9_bKe2ForzeiWGrmjep0IJOmBc9-sNZ9vHiALQpUFAZwzvRpgydY5gSXFtwXDBLv_fPpN51XNreHk7VTCR86wsDTk96w/w510-h292/9.png)
10.Tambahkan Entitas MataKuliah
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhk3_QgxMv11PZDs-VtkXPFQtEfXCPJQn5s0hM92PyBKeKAkEMZWoxj2edu3vXtZcjbugmJRKBdXjnd2Ps5wGYpyCHt3wFDm6s88Hv8WsclY_tOzosIujwApNIegvfSYXVmcVkxShuCyiI/w507-h288/10.png)
11.Tambahkan Entitas Nilai
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg33DCJWZlc45VmxDHfk4S8Qo5ENLskjx0m5C5K9MZFiAUSTy775HBZfKXlxdlAjMC6HrQwMHr3Au7aEmqMocwZYJ16BbgjP_ehhAzhWboa3primHEQSyjQK7-wPzd_U9K_JbJwe8kH8_U/w504-h288/11.png)
12.Pindahkan pembatas di bawah NIM
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDVlmzGDZW49Q8xyLcmx_m-y1TivuzcCiu0s4D7YPR5mfppdxpxVbhSqrRrZhpBgC6lv5kIBUts3C1yS6CMOiDfCc7twon1ZggLbRwFx907N1IP1BNCPfLVNeypcftRgKMk4bAS9tSF_M/w504-h287/12.png)
13.Klik kanan untuk mengeset menjadi Primary Key
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpMcqTzroJ4nud3-X2Tej42WZbX1eKAirLUFA-0KZJHVkGg1QXpv10vV_UlEcjlQMWpKww7n5fWKZK50u3gY8v7SRBTWHEqxa44cre3LJFRcTL6DG1IjfbbJibxCVYg_dN4J5pxuvIn_E/w523-h297/13.png)
14.Set juga menjadi Foreign Key
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgs2b0Z6dZ8lxp3Y6l0sJdR1Hy3L-yvEcc0flQZw2ewB2j2gQaY6B71mpr6sfLTZr8HF5A8qDWWlj6rRy1tML7L_aVlYyPP-2oTNScKNGsbJShsWazVTA6reFjd_MJCRhKoSHJvV7yUh7E/w525-h297/14.png)
15.Hasil sesudah diset menjadi Primary Key dan Foreign Key
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglIzoND2kKV68Dl9sDmp0fwmY_DReRsdhwMS43M3_mCLe4FsG9lSPJrIDkymESCHQRyRM1r_gScQJdQz6UQJbzsFJT0qeq7xO5v8I6ib7DXapiBzR94rRfZbR5Dkl76OdUqAZQVa6URkw/w515-h293/15.png)
16.Klik dan drag Relationship dari Shapes (bagian kiri) ke tengah
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjChaPmlRnmndOV-p-tLd_bxsHKGLsvuhSuVe1F3scatj20pw_GwY5c2-kaIytr7NfJD_q-Anr1ffF6ODdxB71m85_xF2OwhM9h2HKycwVCpHRmtWKGa3YL2vWg7ERujVVCcBWLKMa4VWw/w505-h287/16.png)
17.Tarik ujung dari garis ke Entitas yang mau dihubungkan
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMTn2RaLKizsIvhGfUspNFiylgIt7iP-c3gvQn8LJza0yj1jDXwtq30b1JgG04004zIk-9zEmegcATxte7tdU4PnntY5hWTx7stUoZvrJCA7hC1ynLOH1gCg2E_s4qz_vauoXD30P_SBY/w516-h294/17.png)
18.Klik dan drag hingga tepi dari Entitas berwarna hijau
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmd859h0vv9TvsExAURpvyLJlzLUl_TjzkpFVXLd88bBArysxAgY1SEyan-cm1g5p1bYiabAqpnzXyxYZ1m2PGqMygYoZIkqzYdl1MC5UKu4ykrTgv2IJ0FoDM6cj182v7ABEFMjjY0WU/w510-h287/18.png)
19.Klik dan drag ujung satu lagi ke Entitas Nilai
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDZSMDKbhM-6y6Kh71PCgsS40zxlSE-kmFb-mIgmeSLDTdRts_Ki0zTGfqwqI07FcHuaMq_s22gaImtqM6Q7bhyphenhyphenlUI9Oc5HQ8gv-QQKglv5czO4GTIklFZO7xUe955NqMB089nZCsAwQY/w508-h287/19.png)
20.Klik kanan di Relationship untuk mengatur konstrain kardinalitas.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9oDe6cdCpefbfQoicVTBcXZSBamJSxbV-vbw_8k5T0X2wxbf0EAxDdMcSqHO2LkXSpVhpOBvqiWw6Dy_7hu6EXzWCzL06uk61y-B3hVkDge32e_4UkjFapmMx4DPNG7iljHDe8P3kHLw/w501-h282/20.png)
21.Lakukan juga untuk hubungan antara MataKuliah dengan Nilai
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYt8HIQjKVjziYAxgkyrLiuXb3qW0JBgAGg55AYGA2UFIGmINJjER6i0B-EwaxlyogY9p-Mc4iCHQZ-zfv3x9tnaKMGe2CmUdpyLs4_CsY3xAdv0dA3GjPKahdz-prV1F_r1EFWYg21gk/w500-h282/21.png)
22.Klik Kanan dan pilih Format Shape untuk mengatur ukuran dari ujung relationship
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEib9EQz0qq61SBXY8UkQNyjMW0YXqrkZHyK8HZYMIs3zstTw5PS51aiidKGG-hK__IDNT5ucG_V_2-yC40CC4DY0l-z7PNWt0EvxGtwRrnet4j-32VlOgQU5rQ9bzx8iiKe9wVjh3pkVwg/w519-h293/22.png)
23.ERD yang sederhana sudah selesai dibuat
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDSxmVz2ydkdLqNt6V7Y6gGZv6FSw2tjaPsDHh1hpIZEWyCii3y-1vMwBO_hbyDHdVIFB3u7jHciYQQQrV98GUrU20SG2VhOhdpkmtNpRTCTspyCmj2AoWtnqQNXRGOijaVBLHpwidhoI/w512-h292/23.png)
13.Klik kanan untuk mengeset menjadi Primary Key
Posting Komentar untuk "Langkah - Langkah Pembuatan ERD di Microsoft Visio"