BASIS DATA Ahmadi Irmansyah Lubis iv | Kitab Basis Data
Dengan senang hati, kami mempersembahkan buku "Kitab Basis Data" ini kepada para pembaca setia yang tengah menjelajahi dunia ilmu data. Buku ini bertujuan untuk memberikan pemahaman mendalam tentang konsep, metode, dan aplikasi dalam bidang sains data yang semakin vital dalam era digital ini. Semoga buku ini dapat menjadi panduan yang bermanfaat bagi pembaca dalam memahami dan mengaplikasikan pengetahuan data science secara efektif. Selamat membaca! Kitab Basis Data | v
KATA PENGANTAR ....................................................... v DAFTAR ISI .................................................................... vi BAB 1 Pengenalan Basis Data .......................................... 1 A. Pendahuluan .................................................................. 2 B. Analogi Konsep Basis Data .......................................... 3 C. Komponen Basis Data ................................................... 4 D. Tujuan Basis Data......................................................... 7 1) Redundansi dan inkonsistensi data.............................. 8 E. Contoh Penerapan Basis Data .................................... 14 F. Rangkuman .................................................................. 19 G. Latihan ......................................................................... 21 BAB 2 Kategorisasi Basis Data ....................................... 25 A. Pendahuluan ................................................................ 26 B. Basis Data Relasional .................................................. 26 C. Basis Data Non Relasional ......................................... 27 D. Basis Data Hierarki ..................................................... 28 E. Basis Data Objek ......................................................... 30 F. Basis Data Time-Series ............................................... 30 G. Basis Data Geografis ................................................... 31 H. Basis Data Berorientasi Kolom ................................... 33 I. Rangkuman .................................................................. 34 vi | Kitab Basis Data
BAB 3 Pemodelan Basis Data ......................................... 41 A. Pendahuluan ................................................................ 42 B. Entitas (Entity) ........................................................... 43 C. Atribut (Attribute) ...................................................... 49 D. Relasi (Relationship) ................................................... 54 E. Kunci (Key) .................................................................. 61 F. Derajat Relasi (Relationship Degree) ........................ 64 G. Kardinalitas (Cardinality) .......................................... 67 H. Diagram Hubungan Antar Entitas (Entity Relationship Diagram)...................................................... 69 I. Diagram Hubungan Antar Entitas Yang Ditingkatkan (Enhanced Entity Relationship Diagram 83 J. Rangkuman .................................................................. 85 K. Latihan ......................................................................... 87 BAB 4 Model Relasional ................................................. 91 A. Pendahuluan ................................................................ 92 B. Penemu Model Relasional .......................................... 92 C. Definisi Model Relasional ........................................... 93 D. Kelebihan dan Kekurangan Model Relasional .......... 95 E. Terminologi Dalam Model Relasional ....................... 96 F. Kunci Relasional.......................................................... 98 G. Karakteristik Relasional .............................................. 99 Kitab Basis Data | vii
/ Enhanced Entity Relationship Diagram (EERD) Menjadi Skema Relasional.............................................. 101 I. Rangkuman ................................................................ 102 J. Latihan .......................................................................105 BAB 5 Normalisasi Basis Data ..................................... 109 A. Pendahuluan .............................................................. 110 B. Dependensi ................................................................ 112 C. Tahapan Normalisasi ................................................ 121 D. Tujuan dan Manfaat Normalisasi............................ 136 E. Contoh Kasus ............................................................. 139 F. Rangkuman ................................................................ 143 G. Latihan .......................................................................146 BAB 6 Bahasa Query .................................................... 151 A. Pendahuluan .............................................................. 152 B. Data Definition Language (DDL) ........................... 170 C. Data Manipulation Language (DML).....................184 D. Data Control Language (DCL) ................................ 197 E. Intermediate Structured Query Language (SQL) ..205 F. Advanced Structured Query Language (SQL) .......217 G. Basis Data Multimedia .............................................225 H. Contoh Kasus ............................................................. 231 I. Rangkuman ................................................................ 236 J. Latihan .......................................................................237 viii | Kitab Basis Data
A. Pendahuluan .............................................................. 244 B. Definisi Basis Data Client-Server ............................ 246 C. Karakteristik Basis Data Client-Server ...................247 D. Kelebihan dan Kekurangan Basis Data Client-Server .................................................................................... 250 E. Arsitektur Basis Data Client-Server........................ 252 F. Studi Kasus Basis Data Client-Server .....................252 G. Rangkuman ................................................................ 257 H. Latihan .......................................................................259 BAB 8 Basis Data Terdistribusi .................................... 265 A. Pendahuluan .............................................................. 266 B. Definisi Basis Data Terdistribusi............................. 267 C. Karakteristik Basis Data Terdistribusi .................... 268 D. Topologi Distribusi Data ..........................................269 E. Kelebihan dan Kekurangan Basis Data Terdistribusi .................................................................................... 275 F. Fragmentasi Data ...................................................... 279 G. Contoh Kasus ............................................................. 287 H. Rangkuman ................................................................ 294 I. Latihan .......................................................................296 BAB 9 Basis Data Non Relasional ................................ 301 A. Pendahuluan .............................................................. 302 B. Sejarah Singkat Basis Data Non Relasional ...........302 Kitab Basis Data | ix
Fleepit Digital © 2021