"

Contents

  1. Preface

  2. About the Book

  3. Acknowledgements

  4. Acknowledgements: eCampusOntario

  5. Main Body

    1. Chapter 1 Before the Advent of Database Systems

      Adrienne Watt

    2. Chapter 2 Fundamental Concepts

      Adrienne Watt & Nelson Eng

    3. Chapter 3 Characteristics and Benefits of a Database

      Adrienne Watt

    4. Chapter 4 Types of Data Models

      Adrienne Watt & Nelson Eng

    5. Chapter 5 Data Modelling

      Adrienne Watt

    6. Chapter 6 Classification of Database Management Systems

      Adrienne Watt

    7. Chapter 7 The Relational Data Model

      Adrienne Watt

    8. Chapter 8 The Entity Relationship Data Model

      Adrienne Watt

    9. Chapter 9 Integrity Rules and Constraints

      Adrienne Watt & Nelson Eng

    10. Chapter 10 ER Modelling

      Adrienne Watt

    11. Chapter 11 Functional Dependencies

      Adrienne Watt

    12. Chapter 12 Normalization

      Adrienne Watt

    13. Chapter 13 Database Development Process

      Adrienne Watt

    14. Chapter 14 Database Users

      Adrienne Watt

    15. Chapter 15 SQL Structured Query Language

      Adrienne Watt & Nelson Eng

    16. Chapter 16 SQL Data Manipulation Language

      Adrienne Watt & Nelson Eng

      1. SELECT Statement
      2. Built-in Functions
      3. Joining Tables

  6. Appendix A University Registration Data Model Example

  7. Appendix B Sample ERD Exercises

  8. Appendix C SQL Lab with Solution

    1. Part 1 – DDL
    2. Part 2 – Create the Following SQL Statements
    3. Part 3 – Insert, Update, Delete, Indexes

  9. About the Authors