Chapter 7. Establishing Table Structures


         It is a capital mistake to theorize                  before one has data.

 --Sherlock Holmes, The Adventures of Sherlock Holmes

Topics Covered in This Chapter

  • Defining the Preliminary Table List

  • Defining the Final Table List

  • Associating Fields with Each Table

  • Refining the Fields

  • Refining the Table Structures


  • Summary

A database is used to keep track of various subjects that are important to an organization. For example, a medical clinic needs to keep track of, among other things, its "Patients," "Doctors," and "Appointments;" an equipment-rental business must maintain such data as its "Customers," "Equipment," and "Rental Agreements;" and a registrar's office is concerned (at least) with "Students," ...

Get Database Design for Mere Mortals now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.