Share this Page URL

Chapter 2. The Basics of Database Design > Normalization: Achieving a Well-Desi... - Pg. 58

The Basics of Database Design 58 You could add SupplierID to the Products table as a foreign key and then create a relationship between the tables. · Third normal form For a table to be in third normal form, it must meet the criteria of the first and second normal forms, and the fields must be mutually independent (that is, the values in the nonkey fields in that table must not depend on the value of another field in the table). For ex- ample, you would seldom want to create a field for data whose value is derived through a formula or another calculation. You would usually not create a field named Total to store the results of