Examples:
The following table is NOT in Third Normal Form: In this example, the city and state are dependent upon the ZIP code. To
place this table in 3NF, two separate tables would be created -- one containing
the company name and ZIP code and the other containing city, state, ZIP code
pairings. This may seem overly complex for daily applications and indeed it
may be. Database designers should always keep in mind the tradeoffs
between higher level normal forms and the resource issues that complexity
creates.
Related Resources:
Definition:
In order to be in Third Normal Form, a relation
must first fulfill the requirements to be in Second Normal Form. Additionally,
all attributes that are not dependent upon the primary key must be eliminated.
Related Terms
• Normalization
• First Normal
Form
• Second
Normal Form
Company
City
State
ZIP
Acme Widgets
New York
NY
10169
ABC Corporation
Miami
FL
33196
XYZ, Inc.
Columbia
MD
21046
Database
Design
Visit our database design subject page for more on normal forms and
normalization
<Back to Last Page> <Full Glossary>
Third
Normal Form (3NF)
<Back to Last Page> <Full Glossary>
Explore Databases
Must Reads
About.com Special Features
Build Your Own Website
Step-by-step advice on how to do everything from choosing a Web host to promoting your content. More >
Connect Your Home Computers
Easy ways to connect two computers for networking purposes. More >
©2009 About.com, a part of The New York Times Company.
All rights reserved.