Using the Table Analyzer to Create Relationships

At this point, are you completely satisfied with the design? Let’s see whether the Table Analyzer agrees with you. This utility reviews current entries and makes suggestions on improving the design.

In a nutshell, the utility looks for repeated data and helps you copy that data to a new and related table. Not every table will need changes, but it doesn’t hurt to run the analyzer just to see what it proposes. In addition, until you’re more familiar with design rules, you can rely on the Table Analyzer to help you through the process of creating properly normalized tables. (Refer to Chapter 4 for a definition of normalization.) To analyze the plant table, follow these steps: