Database Reference
In-Depth Information
Figure 7.22. Resolving the multipart fields in the INSTRUCTORS table
The redundancy in the new tables is acceptable because, once again, it is minimal. In
Chapter 10
,
you'll learn how to reduce this type of redundancy even further by relating the
tables with primary keys and foreign keys.
Refining the Table Structures
Now that you've refined the fields and made certain that each field is sound, you can
begin the process of refining the table structures. Your objective in this phase of the design
process is to make sure that you've assigned the appropriate fields to each table and that
you've properly defined each table's structure. This process will also reveal whether the
tables have anomalies that you need to resolve.
