15.00 - Modeling 1:M Relationships - Teradata Database

Teradata Database Design

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

Modeling 1:M Relationships

1:M relationships are modeled by placing the primary key of entity A as a foreign key component of entity B.

Example

Because 1:M relationships are asymmetric, the entity A key must be placed in entity B. The reciprocal relationship does not model the same E-R relationship.