15.00 - Guideline for Placing the Foreign Key - Teradata Database

Teradata Database Design

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

Guideline for Placing the Foreign Key

Place the foreign key in whichever entity minimizes or eliminates the possibility of nulls.

Example

Because of the symmetry of 1:1 relationships, the following entity pairs both model the same relationship: