15.00 - Denormalized Table Set - Teradata Database

Teradata Database Design

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

Denormalized Table Set

The first set of tables is denormalized by including current_effective_date and current_price_amount columns in the part table. Because the price of the part is also carried in the part_price_history table, this is a violation of normalization due to redundant data.