Page 8 - E-Modul Simbad_Neat
P. 8
4.4 Normalisasi dengan Ketergantungan Fungsional ................................... 61
BAB 5. Model Data ............................................................................................. 84
5.1 Fakta Dunia Nyata (Real World) ............................................................ 84
5.2 Model Entity-Relationship (Model Keterhubungan Entitas) .................. 86
5.3 Diagram Entity-Relationship (Diagram E-R) ......................................... 96
5.4 Varian Entitas ....................................................................................... 114
5.5 Varian Relasi ........................................................................................ 117
5.6 Spesialisasi dan Generalisasi ................................................................ 121
BAB 6. Penerapan Basis Data .......................................................................... 126
6.1 Transformasi Model Data ke Basis Data Fisik ..................................... 127
6.2 DBMS dan Struktur Tabel .................................................................... 138
6.3 Indeks dan Struktur Penyimpanan ........................................................ 144
BAB 7. Bahasa Query ....................................................................................... 154
7.1 Bahasa Query Formal ........................................................................... 155
7.2 Bahasa Query Terapan ......................................................................... 168
BAB 8. Pemrosesan Query ............................................................................... 177
8.1 Klasifikasi Aktivitas ............................................................................. 177
8.2 Operasi Seleksi ..................................................................................... 180
8.3 Operasi Join .......................................................................................... 186
8.4 Operasi Lain ......................................................................................... 189
8.5 Struktur Sistem Basis Data ................................................................... 190
8.6 Struktur DBMS untuk Pemrosesan Query ........................................... 190
BAB 9. Pengamanan Basis Data ...................................................................... 193
9.1 Pengamanan Basis Data (Database Security) ...................................... 193
9.2 Pemeliharaan Integritas Basis Data (Database Integrity) .................... 200
BAB 10. Basis Data Terdistribusi .................................................................... 203
viii
