In this video, we discuss third normal form 3nf in data normalization as covered information Systems and Controls ISC CPA Exam.
Start your free trial: https://farhatlectures.com/

Third Normal Form (3NF) is a level of database normalization that aims to reduce the redundancy and dependency of data by ensuring that it meets all the criteria for Second Normal Form (2NF) and additional requirements specific to 3NF. To explain 3NF, we'll build on the concepts of the First (1NF) and Second (2NF) Normal Forms:

First Normal Form (1NF): Requires that all table columns contain only atomic (indivisible) values and each column has a unique name. There should be no repeating groups or arrays.
Second Normal Form (2NF): A table must be in 1NF and every non-key attribute must be fully functionally dependent on the primary key, meaning no part of the primary key can determine a non-key attribute. This eliminates partial dependency.
Third Normal Form (3NF): A table must be in 2NF, and it must ensure that all non-key attributes are not only fully functionally dependent on the primary key but are also non-transitively dependent. This means that no non-key attribute depends on another non-key attribute. In simpler terms, every non-key attribute should depend only on the primary key and nothing else.


#cpaexaminindia #cpaexam #cpareviewcourse