Normal Forms - Teradata Vantage - Analytics Database

Database Introduction

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-09-27
dita:mapPath
gtm1628096154303.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dsm1472253642401
lifecycle
latest
Product Category
Teradata Vantageā„¢

A normal form defines a system of constraints. If a relation meets the constraints, the relation is in normal form.

By definition, a relational database is normalized to first normal form, because the column values are always atomic. That is, a column must contain exactly one value or null.

However, a database in first normal form is vulnerable to redundancy and update anomalies. The higher normal forms correct those problems.