Translating Entities and Relationships Into Tables
Definition of a Prime Table
A prime table is a table that has a single column primary key.
Prime tables always model entities and all entities are modeled by prime tables.
Ensure that all prime tables have been defined prior to defining any associative tables (see “Definition of an Associative Table” on page 68).
The following table, Table_A, is prime because it has a simple primary key (see the definition for “Simple key” under “Definitions” on page 78):
|
Table_A |
|
A_Key |
|
PK |
|
A1 |
|
A2 |
|
A3 |