Analisa Konsep Database

ANALISA KONSEP DATABASE
- Tehnik merancang model konseptual dgn model data relational
- Tehnik Normalisasi
- Tehnik Entity Relationship

TEKNIK NORMALISASI
Mrpkn proses pengelompokkan elemen data menjadi tabel2 yg menunjukkan entity & relasinya
Field/key yg digunakan :
- Candidate Key
- Primary Key
- Alternate Key
- Foreign Key

Tahapan Proses Normalisasi :
- UnNormalized Form
- First Normal Form/1Nf
- Second Normal Form/2Nf
- Third Normal Form/3Nf
- Boyce-Codd Normal Form/BCNf

ENTITY RELATIONSHIP DIAGRAM
Proses hubungan antar file yg direlasikan dgn relation key yg merupakan primary key dari masing- masing file
Hubungan/relasi antar file
a. One To One Relationship 2 file
b. One To Many Relationship 2 file
c. Many To Many Relationship 2 file
d. Relasi One To One 2 attribue dalam 1 file
e. Relasi Many To One 2 attribue dalam 1 file
f. Relasi Many To Many 2 attribue dalam 1 file

Tweet