Page 5 - E-Modul Sistem Basis Data
P. 5
3.1 Definisi Basis Data Relasional ............................................................... 22
3.2 Basis Data Akademik ............................................................................. 22
3.3 Operasi dan Bahasa Basis Data .............................................................. 29
3.4 Relasi Antartabel .................................................................................... 33
3.5 Basis Data yang Baik ............................................................................. 37
BAB 4. Normalisasi Data .................................................................................... 42
4.1 Atribut Tabel (Table Attribute) .............................................................. 42
4.1.1 Key dan Atribut Deskriptif .............................................................. 43
4.1.2 Atribut Sederhana (Simple Atribute) dan Atribut Komposit
(Composite Attribute) ................................................................................ 45
4.1.3 Atriubut Bernilai Tunggal (Single-Valued) dan Atribut Bernilai
Banyak (Multivalued Attribute) ................................................................ 46
4.1.4 Atribut Harus Bernilai (Mandatory Attribute) dan Nilai Null ......... 47
4.1.5 Atribut Turunan (Derived Attribute) ................................................ 48
4.2 Domain dan Tipe Data ........................................................................... 49
4.3 Ketergantungan Fungsional (Functional Dependency) .......................... 50
4.4 Normalisasi dengan Ketergantungan Fungsional ................................... 53
4.4.1 Lossles-Join Decomposition ............................................................ 57
4.4.2 Dependency Preservation ................................................................ 60
4.4.3 Boycee-Codd Normal Form (BCNF) ............................................... 61
4.4.4 Bentuk Normal Tahap Ketiga (3rd Normal Form) .......................... 68
BAB 5. Model Data ............................................................................................. 70
5.1 Fakta Dunia Nyata (Real World) ............................................................ 70
5.2 Model Entity-Relationship (Model Keterhubungan Entitas) .................. 72
5.2.1 Entitas (Entity) dan Himpunan Entitas (Entity Set) ......................... 73
5.2.2 Atribut (Attributes/Properties) ......................................................... 74
v