The Third Normal Form (3NF)
The Third Normal Form or 3NF method of database modeling in a nutshell is all about the primary key. What this means is there is no data element in the database that cannot be referenced by the primary key. To achieve 3NF a database must also pass the first levels on normalization.
In the First Normal Form or 1NF the theory is that all of the data in all of the columns must be atomic. This means there can be no sets of data in one column. For instance, a name column that contains both first and last names has sets of data. It is better to have one column for the first name and a separate column for the last name.
To pass the Second Normal Form or 2NF the data must be 1NF compliant and now must also be more key dependent. ...
Get Oracle Essbase 9 Implementation Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
