A to Z GIS | Explore this related guide, featuring updated terms and graphics and developed in coordination with Esri’s GIS Dictionary team.
Learn more about A to Z GIS
GIS Dictionary
Browse dictionary
normal form
URL copiedShare URL
[database structures]
A set of guidelines for designing table and data structures in a relational database. When followed, normal form guidelines prevent data redundancy, increase database efficiency, and reduce consistency errors. A database is said to be in first normal form (1NF), second normal form (2NF), third normal form (3NF), and so on, depending on the level of normal form guidelines followed in its design. In practice, 3NF is commonly used, but higher levels are rarely used.