theFile





ii | Kitab Basis Data

ii | Kitab Basis Data

Kitab Basis Data | iii

Kitab Basis Data | iii

KITAB

BASIS DATA Ahmadi Irmansyah Lubis iv | Kitab Basis Data

KITAB

KATA PENGANTAR

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

DAFTAR ISI

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

DAFTAR ISI

J. Latihan ......................................................................... 36

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

J. Latihan ......................................................................... 36

H. Menerjemahkan Entity Relationship Diagram (ERD)

/ 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

H. Menerjemahkan Entity Relationship Diagram (ERD)

BAB 7 Basis Data Client – Server................................. 243

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

BAB 7 Basis Data Client – Server................................. 243



Flipbook Gallery

Magazines Gallery

Catalogs Gallery

Reports Gallery

Flyers Gallery

Portfolios Gallery

Art Gallery

Home


Fleepit Digital © 2021