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
   1   2   3   4   5   6   7   8   9   10   11