Microsoft Azure Data Fundamentals DP-900 Practice Question

In third normal form, each non-key attribute must depend only on the primary key. By moving supplier contact information to its own table and referencing it with a foreign key, the same supplier data is stored once instead of being repeated in every product row. This reduces redundant data and prevents update, insert, and delete anomalies that occur when the same facts are duplicated in multiple places. Creating separate tables does not eliminate the need for primary keys, automatically create indexes for every query, or turn all one-to-many relationships into many-to-many relationships.