OCI Interview Question:

What is database normalization?

Submitted by: Administrator

Normalization means the process in which raw data is
converted to filtered data.
Types of Normalization are:- 1NF,2NF,3NF.

1NF:- Table that contains one or more repeating groups
Identify and remove repeating groups.

2NF:-Describes a table that is fully functionally dependent
Full functional dependency - means that if B is
functionally dependent on A but not on any proper subset of
A, it is fully functionally dependent on A
Partial dependency - is if there are some attributes from A
that can be removed and the dependency still holds

3NF:- In 3NF we remove the transitive dependencies.
Transitive dependency - A->B and B->C implies that A->C
C is transitionally dependent on A through B
Submitted by: Administrator