2007

Inside Relational Databases with Examples in Access

Authors:

ISBN: 978-1-84628-394-9 (Print) 978-1-84628-687-2 (Online)

Table of contents (36 chapters)

previous Page of 2
  1. Front Matter

    Pages i-xiv

  2. Introduction

    1. No Access

      Book Chapter

      Pages 1-9

      Introduction

  3. A simple, single-table database

    1. Front Matter

      Pages 11-11

    2. No Access

      Book Chapter

      Pages 13-16

      Introduction to Part 1

    3. No Access

      Book Chapter

      Pages 17-35

      Tables

    4. No Access

      Book Chapter

      Pages 36-44

      Queries/Views

    5. No Access

      Book Chapter

      Pages 45-53

      Forms

    6. No Access

      Book Chapter

      Pages 54-55

      Reports

    7. No Access

      Book Chapter

      Pages 56-58

      Summary of Part 1

  4. A multi-table database

    1. Front Matter

      Pages 59-59

    2. No Access

      Book Chapter

      Pages 61-61

      Introduction to Part 2

    3. No Access

      Book Chapter

      Pages 62-66

      Serious problems with single tables

    4. No Access

      Book Chapter

      Pages 67-72

      Multiple tables cure serious problems

    5. No Access

      Book Chapter

      Pages 73-74

      Making multiple tables work together

    6. No Access

      Book Chapter

      Pages 75-80

      Getting the data into the correct tables

    7. No Access

      Book Chapter

      Pages 81-83

      Relationships in the real world

    8. No Access

      Book Chapter

      Pages 84-111

      How are relationships modeled?

    9. No Access

      Book Chapter

      Pages 112-126

      Revisiting the big four — the synergy begins

    10. No Access

      Book Chapter

      Pages 127-145

      Integrity

    11. No Access

      Book Chapter

      Pages 146-146

      Summary of Part 2

  5. Database Design & Architecture

    1. Front Matter

      Pages 147-147

    2. No Access

      Book Chapter

      Pages 149-164

      Database design

    3. No Access

      Book Chapter

      Pages 165-167

      The seven layers of wisdom

    4. No Access

      Book Chapter

      Pages 168-177

      Database architecture

previous Page of 2