15.00 - Denormalizing With Repeating Groups - Teradata Database

Teradata Database Design

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

Denormalizing With Repeating Groups

Repeating groups are attributes of a non-1NF relation that would be converted to individual tuples in a normalized relation.

Example  

For example, this relation has six attributes of sales amounts, one for each of the past six months:

 

When normalized, the Sales History relation has six tuples that correspond to the same six months of sales expressed by the denormalized relation: