3NF (Third Normal Form)

“Third normal form modelling is a classical relational-database modelling technique that minimizes data redundancy through normalization. When compared to a star schema, a 3NF schema typically has a larger number of tables due to this normalization process… 3NF schemas are typically chosen for large data warehouses, especially environments with significant data-loading requirements that are used to feed data marts and execute long-running queries.” Glossary, Oracle® Database Data Warehousing Guide 10g Release 2 (10.2) Part Number B14223-02