Second Normal Form - 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ā„¢

Second normal form (2NF) eliminates circular dependencies from a relation. A relation is in 2NF if it is in 1NF and if every non-key attribute is fully dependent on the Primary Key.

A non-key attribute is an attribute that is not part of the Primary Key for the relation.