Denormalized Table Set - Teradata Database

Teradata Database Design

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

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.