Implementasi Normalisasi Dalam Perancangan Database Relational

  • Sudi Suryadi Fakultas Teknik - Universitas Al-Washliyah Labuhanbatu
DOI: https://doi.org/10.52332/u-net.v3i2.7
Keywords: normalisasi, relasi, rdms, database

Abstract

Dalam merancang sebuah database relasional, untuk kebutuhan sistem informasi dibutuhkan suatu Teknik yang disebut dengan Normalisasi. Dengan adanya teknik ini memungkinkan menghindari terjadinya berbagai anomali data dan tidak konsistensinya sebuah data. Dalam beberapa kasus normalisasi ini sangat penting untuk menunjang kinerja database dan memastikan bahwa data dalam database tersebut aman dan tidak terjadi kesalahan jika mendapat perintah SQL terutama DML yaitu update, insert, dan delete. Normalisasi menggunakan tahap-tahapan  dalam penyelesaiannya yang disebut dengan 1NF, 2NF, 3NF, BCNF, 4NF, 5NF, DKNF, 6NF, setiap tahapan-tahapan memiliki ciri-ciri dalam penyelesaiannya

Downloads

Download data is not yet available.

References

Bahmani A., Naghibzadeh, M. and Bahmani, B., “Automatic database normalization and primary key generation”, Niagara Falls Canada IEEE, 2008

Date C.J., “Pengenalan Sistem Basis Data jilid 1”, PT.Indeks Group Gramedia, 2004

Demba M, “An Algorithmic Approach to Database Normalization”, International Journal of Digital Information and Wireless Communications (IJDIWC) 3(2): 197-205, The Society of Digital Information and Wireless Communications, 2013 (ISSN: 2225-658X)

Elmasri &Navathe. “Fundamentals of Database Systems”, Addison-Wesley, 2003Fathansyah, Basis Data,Bandung: Informatika, 2012

Published
2019-08-03
How to Cite
[1]
S. Suryadi, “Implementasi Normalisasi Dalam Perancangan Database Relational”, u-net, vol. 3, no. 2, pp. 20-26, Aug. 2019.
Issue
Vol. 3 No. 2 (2019): U-NET Jurnal Teknik Informatika | Agustus
Section
Research Article
Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

Authors who publish with this journal agree to the following terms:

  1. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
  2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
  3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).