NORMALIZATION IN DATABASE DESIGN

Authors

  • Zainul Efendy STMIK Indonesia Padang

DOI:

https://doi.org/10.24014/coreit.v4i1.4382

Abstract

This research is done to find a simple solution how to find a normalization techniques are appropriate in database design, normalization techniques has several steps of which are forms of abnormal, normalization first, normalization 2st and normalization 3st, only 3 stages rare to be discussed in this study, as in lectures often find their students do not understand to implement this normalization techniques. The results of this study include determining the database data structures, forming sql (structural query language) by using MySQL DBMS and prototype transaction model form.

References

D. Mentari, “Implementasi Normalisasi Database,” Biltek Vol. 3, No. 006 Tahun 2014, vol. 3, no. 70, pp. 1–7, 2014.

G. Triyono, “Pertimbangan Melakukan Denormalisasi Pada Model Basis Data Relasi,” J. Telemat. MKOM, vol. 3, no. 2, pp. 19–25, 2011.

Gat, “Perancangan Basis Data Perputakaan Sekolah dengan Menerapkan Model Data Relasional,” Citec, vol. 2, No. 4, pp. 304–315, 2015.

L. A. Abdillah, “Perancangan basisdata sistem informasi penggajian,” J. Ilm. MATRIK, vol. Vol.8 No.2, pp. 135–152, 2006.

T. Pauliana, “Seminar Internasional , ISSN 1907-2066 Seminar Internasional , ISSN 1907-2066,” Pap. Semin. Sist. Inf. Manaj., pp. 1307–1312, 2007.

Downloads

Published

2018-06-19

Issue

Vol. 4 No. 1 (2018): Juni 2018

Section

Articles

License

The Authors submitting a manuscript do so on the understanding that if accepted for publication, copyright of the article shall be assigned to CoreIT journal and published by Informatics Engineering Department Universitas Islam Negeri Sultan Syarif Kasim Riau as publisher of the journal.

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

Authors automatically transfer the copyright to the journal and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-ShareAlike (CC BY SA) that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.

Authors are able to enter into separate permission for 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 acknowledgement of its initial publication in this journal.

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).