Soal UTS Dan UAS AMIKOM: Basis Data

Definisi : Program yang memungkinkan item-item dalam suatu database disusun, diolah dan diperbaharui<br />
Contoh:<br />
<ul>
<li><b>Oracle</b></li>
<li><b>My SQL</b></li>
<li><b>Microsoft Access</b></li>
<li><b>Paradox</b></li>
<li><b>Interbase </b></li>
<li><b>Microsoft SQL Server 2000</b></li>
</ul>
<div>
<span style="font-family: 'Bookman Old Style';"><b>Microsoft SQL Server 2000</b></span></div>
<div>
<span style="font-family: Bookman Old Style;"><b>-</b></span>Master : <b>fasilitas untuk gabungan dari tabel-tabel sistem</b> yang mencatat instalasi server secara keseluruhan dan seluruh database dibuat secara konsekuen</div>
<div>
-Model : template database, setiap <b>proses pembuatan database</b></div>
<div>
-Pups : Database Contoh</div>
<div>
-Nortwind : Database Contoh</div>
<div>
-Msdb : Database yang berisi penjadwalan dan pesan </div>
<div>
-Tempdb : Database yang digunakan untuk menyimpan tabel temporary yang<span style="font-family: 'Gill Sans MT'; font-size: 21pt; line-height: 90%;"> </span>dibuat oleh SQL Server</div>
<div>
<br /></div>
<b>SQL Server Service Manager</b><br />
<div>
<br /></div>
<div>
Cara :<br />
<div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; unicode-bidi: embed; vertical-align: baseline;">
-Start <br />
-Program <br />
-Microsoft SQL Server <br />
-Service Manager</div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEia3Dl5WHvLLVqxxEKjjWWxuVMi0jWZGFr9jm4joz23kG0TxcbmSGJwm_rZJllPT_Sik81Ub5qxMmKeh9iDcz24vynOr-_vgOhoKTQ_vNjN3W9HcxWkXKeRUIsHlSi3j2CO_Z-gE5t71BPl/s1600/Picture1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="276" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEia3Dl5WHvLLVqxxEKjjWWxuVMi0jWZGFr9jm4joz23kG0TxcbmSGJwm_rZJllPT_Sik81Ub5qxMmKeh9iDcz24vynOr-_vgOhoKTQ_vNjN3W9HcxWkXKeRUIsHlSi3j2CO_Z-gE5t71BPl/s320/Picture1.png" width="320" /></a></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; unicode-bidi: embed; vertical-align: baseline;">
<br /></div>
<div>
<b><br /></b></div>
</div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<b>SQL Server Interprise Manager</b><br />
<div>
Cara :<br />
<div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; unicode-bidi: embed; vertical-align: baseline;">
-Start <br />
-Program <br />
-Microsoft SQL Server <br />
-Interprise Manager</div>
</div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaZNmgPzjZAUiz6zr_oMAncrmqZv5Qlc9O8AQv0XjvjdCezM3a1zZ0ioK9EUezb4FHbGtPR0vghGXWwW17vB-9WGxhFFhKTkWJOCQbknPdx-U6dScgj4W4vJUhJCTtcjcBcb9qsKIYugU-/s1600/Picture2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="173" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaZNmgPzjZAUiz6zr_oMAncrmqZv5Qlc9O8AQv0XjvjdCezM3a1zZ0ioK9EUezb4FHbGtPR0vghGXWwW17vB-9WGxhFFhKTkWJOCQbknPdx-U6dScgj4W4vJUhJCTtcjcBcb9qsKIYugU-/s320/Picture2.png" width="320" /></a></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; unicode-bidi: embed; vertical-align: baseline;">
<br /></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; unicode-bidi: embed; vertical-align: baseline;">
<br /></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; unicode-bidi: embed; vertical-align: baseline;">
<br /></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; unicode-bidi: embed; vertical-align: baseline;">
<br /></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; unicode-bidi: embed; vertical-align: baseline;">
<br /></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; unicode-bidi: embed; vertical-align: baseline;">
<br /></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; unicode-bidi: embed; vertical-align: baseline;">
<br /></div>
<b></b><br />
<div>
<b><b><br /></b></b></div>
<b>
Membuat User</b><br />
<div>
-Dari Interprise Manager <br />
-Security – Logins <br />
-Action – New Login <br />
Atau <br />
-Klik kanan – New Login </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1_BeJf6ylYbuIz469a2mjO2p173r0_7jSRIzjMthYZ8SPA-vjOWesCVts0FQPtAEurAJYQQdQWbOItwa1Inhynu82S08ZLNNSVIRxG8B73le_7z3JNXcaRCEvfXUY9ca1NYseS47IGthy/s1600/Picture3.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1_BeJf6ylYbuIz469a2mjO2p173r0_7jSRIzjMthYZ8SPA-vjOWesCVts0FQPtAEurAJYQQdQWbOItwa1Inhynu82S08ZLNNSVIRxG8B73le_7z3JNXcaRCEvfXUY9ca1NYseS47IGthy/s200/Picture3.png" width="180" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<b>Membuat Database dengan Interprise Manager</b><br />
<div>
-Dari Interprise Manager <br />
-Klik Databases <br />
-Action – New Database <br />
atau<br />
-Klik kanan – New Database <br />
-File yang dibuat: <br />
-File transaksi : *.mdf <br />
-File log : *.ldf <br />
-Default direktori: <br />
c:\program files\microsoft sql server\mssql\data</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidEmeuZ-7XexW0FSj7gTlPHHAHZ_WvUTB9qOKL3XoWBTSA_43fMu1Xeux2FwHRbCPDaWLMDnZ47T1AAAzxG0AGceItFvB7Pp2I4OblCEosstrgsF29fdPwC24FUxmwX-jQltaASbCHtn20/s1600/Picture4.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="191" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidEmeuZ-7XexW0FSj7gTlPHHAHZ_WvUTB9qOKL3XoWBTSA_43fMu1Xeux2FwHRbCPDaWLMDnZ47T1AAAzxG0AGceItFvB7Pp2I4OblCEosstrgsF29fdPwC24FUxmwX-jQltaASbCHtn20/s200/Picture4.png" width="200" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<b>Membuat Tabel</b><br />
<div>
<b><br /></b>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkaytr1BjCDGdQVpsFk1jreruzJGwTqYWyRGvQJIoDI5jU5BIJMl9mnmeQYOMZhVG0B-yc49tamvT35uSBveNyhG-KNfuxTg8OS9z849la8iMBU0KeIqDEp4SgdUcyFEkLqPg1mZdjgmd5/s1600/Picture5.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkaytr1BjCDGdQVpsFk1jreruzJGwTqYWyRGvQJIoDI5jU5BIJMl9mnmeQYOMZhVG0B-yc49tamvT35uSBveNyhG-KNfuxTg8OS9z849la8iMBU0KeIqDEp4SgdUcyFEkLqPg1mZdjgmd5/s200/Picture5.png" width="161" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1dy5wR3cEQGmSce6eg2Eo5d3tH-QFVlOniK5FmwcB9JkrlpbURZTREkQTvVSi6IGj1tcI0k_102I-BW_W5aAkR0Og9kEaPJQLum2fnwZQOgrsEhOxhyxZTjM6g4gg5UxkRtwSXx0GsCnY/s1600/Picture6.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="138" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1dy5wR3cEQGmSce6eg2Eo5d3tH-QFVlOniK5FmwcB9JkrlpbURZTREkQTvVSi6IGj1tcI0k_102I-BW_W5aAkR0Og9kEaPJQLum2fnwZQOgrsEhOxhyxZTjM6g4gg5UxkRtwSXx0GsCnY/s200/Picture6.png" width="200" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSCcbkCKjGJ62itWCm7JQgYvVg-etIbRiN9iOHQscaKjz9y2meGSIBukfXMonPURGBgfE6qDEpWSGBm2U-sOuPXUk1x6KzneYOdD-xfEjml_QkNCkVY2Qe2ppoBfNJbvO9LNAtIypW4NvP/s1600/Picture7.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="174" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSCcbkCKjGJ62itWCm7JQgYvVg-etIbRiN9iOHQscaKjz9y2meGSIBukfXMonPURGBgfE6qDEpWSGBm2U-sOuPXUk1x6KzneYOdD-xfEjml_QkNCkVY2Qe2ppoBfNJbvO9LNAtIypW4NvP/s200/Picture7.png" width="200" /></a></div>
<div>
<b><br /></b>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
</div>
</div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<b>Membuat Diagram</b><br />
<div>
<b><br /></b>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhuEa_R8J_PXMbzj50Iey9MlXed1x9IPZiQwZ6pVkkHURuHOFo3DSp7-6wHMKR829NeHxJFmIENDIW3YxI6AF7EKOPdXBAT2Hrr1Bz2j9WjB4T8zYsKHA7gwFsZ0BhooAoa50eoXHreOp9P/s1600/Picture10.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhuEa_R8J_PXMbzj50Iey9MlXed1x9IPZiQwZ6pVkkHURuHOFo3DSp7-6wHMKR829NeHxJFmIENDIW3YxI6AF7EKOPdXBAT2Hrr1Bz2j9WjB4T8zYsKHA7gwFsZ0BhooAoa50eoXHreOp9P/s200/Picture10.png" width="170" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnp0w8f_XuZfBropKNj53lJeGl8cmPSaufSwFQdtz56E_e0FWuG2gcV2hsaXozbuWU5LIxWIxroAucUDV4Uq-YjbI85VZ58Io4d9HprGE8aLx24nKQQwXQjAjNh2gH1y0hN0aNsaFASzxI/s1600/Picture8.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnp0w8f_XuZfBropKNj53lJeGl8cmPSaufSwFQdtz56E_e0FWuG2gcV2hsaXozbuWU5LIxWIxroAucUDV4Uq-YjbI85VZ58Io4d9HprGE8aLx24nKQQwXQjAjNh2gH1y0hN0aNsaFASzxI/s200/Picture8.png" width="157" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieVDg8bsNX9g86gnQr4lr31BjXm-xHH12I2j8YwbvqnRtHVdmjZTUhuAVymhAvzswHJ1FLAq9rOSTkp1s_AIE0gXQJT62Kof7vRJnS0ed6yLn0UZxvDY34NF_BaQlp_Uu823E4dEg7sfpG/s1600/Picture9.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="155" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieVDg8bsNX9g86gnQr4lr31BjXm-xHH12I2j8YwbvqnRtHVdmjZTUhuAVymhAvzswHJ1FLAq9rOSTkp1s_AIE0gXQJT62Kof7vRJnS0ed6yLn0UZxvDY34NF_BaQlp_Uu823E4dEg7sfpG/s200/Picture9.png" width="200" /></a></div>
<div>
<b><br /></b>
<div>
<b><br /></b></div>
</div>
</div>

Database Management System (DBMS)

Definisi : Program yang memungkinkan item-item dalam suatu database disusun, diolah dan diperbaharui Contoh: Oracle My SQL Microsoft Ac...