'$7$%$6('(6,*1
                                           Z/EEtdd
      Database Design
      Adrienne Watt
      Port Moody
          Except for third party materials and otherwise stated, content on this site is made available under a Creative Commons Attribution 2.5
          Canada License.
             Contents
             Preface                                                                                                                                  v
                  Adrienne Watt
                  1.   Chapter 1 Before the Advent of Database Systems                                                                                1
                       Adrienne Watt
                  2.   Chapter 2 Fundamental Concepts                                                                                                 4
                       Adrienne Watt
                  3.   Chapter 3 Characteristics and Benefits of a Database                                                                           6
                       Adrienne Watt
                  4.   Chapter 4 Types of Database Models                                                                                             8
                       Adrienne Watt
                  5.   Chapter 5 Data Modelling                                                                                                      10
                       Adrienne Watt
                  6.   Chapter 6 Classification of Database Systems                                                                                  14
                       Adrienne Watt
                  7.   Chapter 7 The Relational Data Model                                                                                           16
                       Adrienne Watt
                  8.   Chapter 8 Entity Relationship Model                                                                                           20
                       Adrienne Watt
                  9.   Chapter 9 Integrity Rules and Constraints                                                                                     29
                       Adrienne Watt
                  10.  Chapter 10 ER Modelling                                                                                                       35
                       Adrienne Watt
                  11.  Chapter 11 Functional Dependencies                                                                                            39
                       Adrienne Watt
                  12.  Chapter 12 Normalization                                                                                                      42
                       Adrienne Watt
                  13.  Chapter 13 Database Development Process                                                                                       47
                       Adrienne Watt
                  14.  Chapter 14 Database Users                                                                                                     54
                       Adrienne Watt
             Appendix A University Registration Data Model example                                                                                   55
             Appendix B ERD Exercises                                                                                                                59
             References and Permissions                                                                                                              61
             About the Author                                                                                                                        62
                                                                                 iv