[database structures]
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.