A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

normal form

[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.

Related Terms