15.00 - Translating Entities and Relationships Into Tables - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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 66).

The following table, Table_A, is prime because it has a simple primary key (see the definition for “Simple key” under “Definitions” on page 75):

 

Table_A

A_Key

PK

A1

A2

A3