Once a database is normalized, relationships between the data in multiple tables must be established. A hefty part of designing a relational database is dividing the data elements into related tables.

This article settles the debate once and for all. By definition, a relational database must contain normalized tables, and to be properly normalized, a table must contain a primary key.