Page 6 - E-Modul Sistem Basis Data
P. 6
5.2.3 Relasi (Relationship) dan Himpunan Relasi (Relationship Sets) ..... 75
5.2.4 Kardinalitas / Derajat Relasi ............................................................ 77
5.3 Diagram Entity-Relationship (Diagram E-R) ......................................... 81
5.3.1 Tahapan Pembuatan Diagram E-R ................................................... 86
5.3.2 Diagram E-R dengan Kamus Data ................................................... 91
5.3.3 Derajat Relasi Minimum .................................................................. 92
5.3.4 Diagram E-R dalam Notasi Lain ...................................................... 94
5.4 Varian Entitas ......................................................................................... 95
5.4.1 Himpunan Entitas Lemah (Weak Entity Sets) .................................. 96
5.4.2 Sub-Entitas (Subtype Entities).......................................................... 97
5.5 Varian Relasi .......................................................................................... 98
5.5.1 Relasi Tunggal (Unary Relation) ..................................................... 99
5.5.2 Relasi Multi-Entitas (N-ary Relation) .............................................. 99
5.5.3 Relasi Ganda (Regundadnt Relation) ............................................. 101
5.6 Spesialisasi dan Generalisasi ................................................................ 102
BAB 6. Penerapan Basis Data .......................................................................... 105
6.1 Transformasi Model Data ke Basis Data Fisik ..................................... 106
6.1.1 Transformasi Umum/Dasar ............................................................ 106
6.1.2 Penerapan Himpunan Entitas Lemah dan Sub-Entitas................... 110
6.1.3 Penerapan Relasi Tunggal (Unary Relation) ................................. 111
6.1.4 Penerapan Multi Entitas (N-ary Relation)...................................... 112
6.1.5 Penerapan Relasi Ganda (Redundant Relation) ............................. 115
6.1.6 Penerapan Spesialisasi dan Generalisasi ........................................ 115
6.2 DBMS dan Struktur Tabel .................................................................... 116
6.3 Indeks dan Struktur Penyimpanan ........................................................ 120
6.3.1 Indeks Primer (Primary Index) ...................................................... 120
vi