Desain Basis Data

Recompile by : Haikal Rahman

Desain Basis Data >> kumpulan proses yang memfasilitasi perancangan, pengembangan, implementasi, dan pemeliharaan sistem manajemen data perusahaan. Basis data yang dirancang dengan benar mudah dipelihara, meningkatkan konsistensi data, dan hemat biaya dalam hal ruang penyimpanan disk. Desainer database memutuskan bagaimana elemen data berkorelasi dan data apa yang harus disimpan.

Model desain data fisik melibatkan penerjemahan desain logis dari database ke media fisik menggunakan sumber daya perangkat keras dan sistem perangkat lunak seperti sistem manajemen basis data (DBMS).

Perancangan database sangat penting >> sistem database berkinerja tinggi .

Siklus hidup pengembangan database

Siklus hidup pengembangan database memiliki sejumlah tahapan yang diikuti saat mengembangkan sistem database.

Langkah-langkah dalam siklus hidup pembangunan tidak harus diikuti secara secara berurutan.

Pada sistem database kecil, siklus pengembangan sistem database biasanya sangat sederhana dan tidak melibatkan banyak langkah.

Untuk mengapresiasi sepenuhnya diagram di atas, mari kita lihat masing-masing komponen yang terdaftar di setiap langkah.

Analisa Kebutuhan

Perencanaan - Tahapan >> berkaitan dengan perencanaan seluruh Siklus Hidup Pengembangan Database. Ini mempertimbangkan strategi Sistem Informasi organisasi.
Definisi sistem - Tahap >> mendefinisikan ruang lingkup dan batasan sistem database yang diusulkan.

Mendesain database

Model logis - Tahap ini berkaitan dengan pengembangan model database berdasarkan persyaratan. Seluruh desain di atas kertas tanpa implementasi fisik atau pertimbangan DBMS khusus.
Model fisik - Tahap ini mengimplementasikan model logis dari database dengan mempertimbangkan DBMS dan faktor implementasi fisik.

Penerapan

Konversi dan pemuatan data - tahap ini berkaitan dengan mengimpor dan mengubah data dari sistem lama ke database baru.
Pengujian - tahap ini berkaitan dengan identifikasi kesalahan dalam sistem yang baru diimplementasikan. Ini memeriksa database terhadap spesifikasi persyaratan.

Sumber : Guru99

Kategori

Computational Technology

Haikal Rahman

Bisnis Digital - FE Unimed

Komentar


<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/4033524873-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'ACvIOeAkLwlk6IQpgAEHPxtFyMfB:1786260214818';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d2771221925127137447','//www.haikalrahman.eu.org/2022/11/desain-basis-data.html','2771221925127137447');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '2771221925127137447', 'title': 'Haikal Rahman', 'url': 'https://www.haikalrahman.eu.org/2022/11/desain-basis-data.html', 'canonicalUrl': 'https://www.haikalrahman.eu.org/2022/11/desain-basis-data.html', 'homepageUrl': 'https://www.haikalrahman.eu.org/', 'searchUrl': 'https://www.haikalrahman.eu.org/search', 'canonicalHomepageUrl': 'https://www.haikalrahman.eu.org/', 'blogspotFaviconUrl': 'https://www.haikalrahman.eu.org/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'id', 'localeUnderscoreDelimited': 'id', 'languageDirection': 'ltr', 'isPrivate': true, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Haikal Rahman - Atom\x22 href\x3d\x22https://www.haikalrahman.eu.org/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Haikal Rahman - RSS\x22 href\x3d\x22https://www.haikalrahman.eu.org/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Haikal Rahman - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/2771221925127137447/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Haikal Rahman - Atom\x22 href\x3d\x22https://www.haikalrahman.eu.org/feeds/691336950594072231/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/3db55d8de4fe007f', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Dapatkan link', 'key': 'link', 'shareMessage': 'Dapatkan link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Bagikan ke Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Bagikan ke X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Bagikan ke Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27id\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'item', 'postId': '691336950594072231', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAVaTidTpBNC4Wj1YyTYPJAbkM88MhUGnkR3ejm41hm8DmmV6qjTSS8-ybqUwpWSV-mTMSLbg_iUGxvUZVrp3GDTUJab_WzE9rbECgFXFwJx9RuMO3huQSsITt0g9MpJ-ud_7tOb3eS7P3LshH8p40kNCWU5yzc4Qmx4p2jiKIJxQ8twwlmzv8Wd_6/s72-c/InformationTech.jpg', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAVaTidTpBNC4Wj1YyTYPJAbkM88MhUGnkR3ejm41hm8DmmV6qjTSS8-ybqUwpWSV-mTMSLbg_iUGxvUZVrp3GDTUJab_WzE9rbECgFXFwJx9RuMO3huQSsITt0g9MpJ-ud_7tOb3eS7P3LshH8p40kNCWU5yzc4Qmx4p2jiKIJxQ8twwlmzv8Wd_6/s16000/InformationTech.jpg', 'pageName': 'Desain Basis Data', 'pageTitle': 'Haikal Rahman: Desain Basis Data', 'metaDescription': ''}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Tautan disalin ke papan klip!', 'ok': 'Oke', 'postLink': 'Tautan Pos'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Khusus', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Desain Basis Data', 'description': 'Blog Materi Kuliah  -  Haikal Rahman | FE Unimed', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAVaTidTpBNC4Wj1YyTYPJAbkM88MhUGnkR3ejm41hm8DmmV6qjTSS8-ybqUwpWSV-mTMSLbg_iUGxvUZVrp3GDTUJab_WzE9rbECgFXFwJx9RuMO3huQSsITt0g9MpJ-ud_7tOb3eS7P3LshH8p40kNCWU5yzc4Qmx4p2jiKIJxQ8twwlmzv8Wd_6/s16000/InformationTech.jpg', 'url': 'https://www.haikalrahman.eu.org/2022/11/desain-basis-data.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 691336950594072231}}, {'name': 'widgets', 'data': [{'title': 'CSS Options', 'type': 'LinkList', 'sectionId': 'elcreative_panel_top', 'id': 'LinkList996'}, {'title': 'Custom SVG Icons', 'type': 'LinkList', 'sectionId': 'elcreative_panel_top', 'id': 'LinkList998'}, {'title': 'Haikal Rahman (Header)', 'type': 'Header', 'sectionId': 'section_app_bar', 'id': 'Header1'}, {'title': 'Navigation Drawer Menu', 'type': 'LinkList', 'sectionId': 'section_navigation', 'id': 'LinkList999'}, {'title': 'More Menu', 'type': 'PageList', 'sectionId': 'section_navigation', 'id': 'PageList999'}, {'title': '', 'type': 'HTML', 'sectionId': 'section_main_top_widget', 'id': 'HTML9'}, {'title': '', 'type': 'HTML', 'sectionId': 'section_main_widget', 'id': 'HTML996'}, {'title': 'Postingan Blog', 'type': 'Blog', 'sectionId': 'section_main_widget', 'id': 'Blog1', 'posts': [{'id': '691336950594072231', 'title': 'Desain Basis Data', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAVaTidTpBNC4Wj1YyTYPJAbkM88MhUGnkR3ejm41hm8DmmV6qjTSS8-ybqUwpWSV-mTMSLbg_iUGxvUZVrp3GDTUJab_WzE9rbECgFXFwJx9RuMO3huQSsITt0g9MpJ-ud_7tOb3eS7P3LshH8p40kNCWU5yzc4Qmx4p2jiKIJxQ8twwlmzv8Wd_6/s16000/InformationTech.jpg', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'Recompile by :'}]}, 'footerBylines': [{'regionName': 'footer2', 'items': [{'name': 'comments', 'label': 'Post a Comment'}]}, {'regionName': 'footer3', 'items': [{'name': 'labels', 'label': 'Kategori'}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'Recompile by :'}, {'name': 'comments', 'label': 'Post a Comment'}, {'name': 'labels', 'label': 'Kategori'}]}, {'title': '', 'type': 'HTML', 'sectionId': 'section_main_bottom_widget', 'id': 'HTML7'}, {'title': 'Tautan Lain', 'type': 'HTML', 'sectionId': 'section_aside_widget', 'id': 'HTML3'}, {'title': 'Kategori', 'type': 'Label', 'sectionId': 'section_aside_widget', 'id': 'Label1'}, {'title': '', 'type': 'HTML', 'sectionId': 'section_aside_widget', 'id': 'HTML8'}, {'title': 'Translate', 'type': 'Translate', 'sectionId': 'section_aside_widget', 'id': 'Translate1'}, {'title': 'Custom Vanilla JavaScript', 'type': 'HTML', 'sectionId': 'elcreative_panel_bottom', 'id': 'HTML998'}, {'title': 'Custom jQuery Script', 'type': 'HTML', 'sectionId': 'elcreative_panel_bottom', 'id': 'HTML999'}, {'title': 'GoogleAds', 'type': 'HTML', 'sectionId': 'hidden', 'id': 'HTML5'}, {'title': 'Formulir Kontak', 'type': 'ContactForm', 'sectionId': 'hidden', 'id': 'ContactForm1'}]}]);
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList996', 'elcreative_panel_top', document.getElementById('LinkList996'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList998', 'elcreative_panel_top', document.getElementById('LinkList998'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'section_app_bar', document.getElementById('Header1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList999', 'section_navigation', document.getElementById('LinkList999'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList999', 'section_navigation', document.getElementById('PageList999'), {'title': 'More Menu', 'links': [{'isCurrentPage': false, 'href': 'https://docs.google.com/forms/d/e/1FAIpQLSeJOjrUJA8KbE_6T1044C0JwBIanpmdqofqh_mSpNZIqYXv6w/viewform', 'title': '\x3csvg width\x3d\x2724\x27 height\x3d\x2724\x27 viewBox\x3d\x270 0 24 24\x27\x3e\x3cpath d\x3d\x27M20 5v14H4V5h16m0-2H4c-1.11 0-2 .89-2 2v14c0 1.11.89 2 2 2h16c1.11 0 2-.89 2-2V5c0-1.11-.89-2-2-2m-2 12H6v2h12v-2m-8-8H6v6h4V7m2 2h6V7h-6v2m6 2h-6v2h6v-2z\x27\x3e\x3c/path\x3e\x3c/svg\x3eDaftar Kelas'}, {'isCurrentPage': false, 'href': 'https://hrnilai.unimed.in/result/?MD', 'title': '\x3csvg width\x3d\x2724\x27 height\x3d\x2724\x27 viewBox\x3d\x270 0 24 24\x27\x3e\x3cpath d\x3d\x27M16.75 22.16L14 19.16L15.16 18L16.75 19.59L20.34 16L21.5 17.41L16.75 22.16M18 2C19.1 2 20 2.9 20 4V13.34C19.37 13.12 18.7 13 18 13V4H13V12L10.5 9.75L8 12V4H6V20H12.08C12.2 20.72 12.45 21.39 12.8 22H6C4.9 22 4 21.1 4 20V4C4 2.9 4.9 2 6 2H18Z\x27\x3e\x3c/path\x3e\x3c/svg\x3eNilai Rutin'}, {'isCurrentPage': false, 'href': 'https://drive.google.com/drive/folders/1vIqRgHlvQiRhovf4-l5GXiEFPwJD6vKQ', 'title': '\x3csvg width\x3d\x2724\x27 height\x3d\x2724\x27 viewBox\x3d\x270 0 24 24\x27\x3e\x3cpath d\x3d\x27M22 8V13.81C21.39 13.46 20.72 13.22 20 13.09V8H4V18H13.09C13.04 18.33 13 18.66 13 19C13 19.34 13.04 19.67 13.09 20H4C2.9 20 2 19.11 2 18V6C2 4.89 2.89 4 4 4H10L12 6H20C21.1 6 22 6.89 22 8M16 18H18V22H20V18H22L19 15L16 18Z\x27\x3e\x3c/path\x3e\x3c/svg\x3eUpload KRS'}, {'isCurrentPage': false, 'href': 'https://haikal.unimed.eu.org', 'title': '\x3csvg width\x3d\x2724\x27 height\x3d\x2724\x27 viewBox\x3d\x270 0 24 24\x27\x3e\x3cpath d\x3d\x27M11 15H17V17H11V15M9 7H7V9H9V7M11 13H17V11H11V13M11 9H17V7H11V9M9 11H7V13H9V11M21 5V19C21 20.1 20.1 21 19 21H5C3.9 21 3 20.1 3 19V5C3 3.9 3.9 3 5 3H19C20.1 3 21 3.9 21 5M19 5H5V19H19V5M9 15H7V17H9V15Z\x27\x3e\x3c/path\x3e\x3c/svg\x3eCourse Outline'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML9', 'section_main_top_widget', document.getElementById('HTML9'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML996', 'section_main_widget', document.getElementById('HTML996'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'section_main_widget', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/402556335-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/828616780-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML7', 'section_main_bottom_widget', document.getElementById('HTML7'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML3', 'section_aside_widget', document.getElementById('HTML3'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label1', 'section_aside_widget', document.getElementById('Label1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML8', 'section_aside_widget', document.getElementById('HTML8'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_TranslateView', new _WidgetInfo('Translate1', 'section_aside_widget', document.getElementById('Translate1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML998', 'elcreative_panel_bottom', document.getElementById('HTML998'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML999', 'elcreative_panel_bottom', document.getElementById('HTML999'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML5', 'hidden', document.getElementById('HTML5'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm1', 'hidden', document.getElementById('ContactForm1'), {'contactFormMessageSendingMsg': 'Mengirim...', 'contactFormMessageSentMsg': 'Pesan sudah dikirim.', 'contactFormMessageNotSentMsg': 'Pesan tidak dapat dikirim. Coba lagi nanti.', 'contactFormInvalidEmailMsg': 'Alamat email harus valid.', 'contactFormEmptyMessageMsg': 'Bidang pesan harus diisi.', 'title': 'Formulir Kontak', 'blogId': '2771221925127137447', 'contactFormNameMsg': 'Nama', 'contactFormEmailMsg': 'Email', 'contactFormMessageMsg': 'Pesan', 'contactFormSendMsg': 'Kirim', 'contactFormToken': 'ACvIOeA-Ofnb8xnhZAYcDznLFlAF:1786260214858', 'submitUrl': 'https://www.blogger.com/contact-form'}, 'displayModeFull'));
</script>
</body>