1 / 21

NORMALISASI

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 .

chibale
Download Presentation

NORMALISASI

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. NORMALISASI DAHLAN ABDULLAH197602282002121005http://www.dahlan.web.id

  2. Normalisasi Basis Data • Normalisasiadalah proses pembentukanstrukturbasis data sehinggasebagianbesarambiguity bisadihilangkan. • TahapNormalisasidimulaidaritahappaling ringan (1NF) hingga paling ketat (5NF) • Biasanyahanyasampaipadatingkat 3NF atauBCNF karenasudahcukupmemadaiuntukmenghasilkantabel-tabel yang berkualitasbaik.

  3. Mengapadilakukannormalisasi • Optimalisasistruktur-strukturtabel • Meningkatkankecepatan • Menghilangkanpemasukan data yang sama • Lebihefisiendalampenggunaanmedia penyimpanan • Mengurangiredundansi • Menghindarianomali (insertion anomalies, deletion anomalies, update anomalies). • Integritas data yang ditingkatkan

  4. SEKIAN …… TERIMA KASIH

More Related