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
second normal form
URL copiedShare URL
[data architecture]
The second level of guidelines for designing table and data structures in a relational database. The second-normal-form guideline incorporates the guidelines of first normal form; in addition, it recommends removing data that applies to multiple rows in a table into its own table and using a foreign key to create a relationship to the original table. A database that follows these guidelines is said to be in second normal form.