normalisasi
DESCRIPTION
NORMALISASI. DAHLAN ABDULLAH 197602282002121005 http://www.dahlan.web.id. Normalisasi Basis Data. Normalisasi adalah proses pembentukan struktur basis data sehingga sebagian besar ambiguity bisa dihilangkan . - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/1.jpg)
NORMALISASIDAHLAN ABDULLAH197602282002121005http://www.dahlan.web.id
![Page 2: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/2.jpg)
Normalisasi Basis Data• Normalisasi adalah proses pembentukan
struktur basis data sehingga sebagian besar ambiguity bisa dihilangkan.• Tahap Normalisasi dimulai dari tahap
paling ringan (1NF) hingga paling ketat (5NF)• Biasanya hanya sampai pada tingkat 3NF
atau BCNF karena sudah cukup memadai untuk menghasilkan tabel-tabel yang berkualitas baik.
![Page 3: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/3.jpg)
Mengapa dilakukan normalisasi
• Optimalisasi struktur-struktur tabel• Meningkatkan kecepatan• Menghilangkan pemasukan data yang sama• Lebih efisien dalam penggunaan media
penyimpanan• Mengurangi redundansi• Menghindari anomali (insertion anomalies,
deletion anomalies, update anomalies).• Integritas data yang ditingkatkan
![Page 4: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/4.jpg)
![Page 5: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/5.jpg)
![Page 6: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/6.jpg)
![Page 7: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/7.jpg)
![Page 8: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/8.jpg)
![Page 9: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/9.jpg)
![Page 10: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/10.jpg)
![Page 11: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/11.jpg)
![Page 12: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/12.jpg)
![Page 13: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/13.jpg)
![Page 14: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/14.jpg)
![Page 15: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/15.jpg)
![Page 16: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/16.jpg)
![Page 17: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/17.jpg)
![Page 18: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/18.jpg)
![Page 19: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/19.jpg)
![Page 20: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/20.jpg)
![Page 21: NORMALISASI](https://reader036.vdokumen.com/reader036/viewer/2022070420/56815ed0550346895dcd5cd5/html5/thumbnails/21.jpg)
TERIMA KASIHSEKIAN ……