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