• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Tapping the Power of Relation... > Using the Table Analyzer to Create R...

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 Plants table, follow these steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint