What is database normalization?
Submitted by: AdministratorNormalization 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
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
Read Online OCI Job Interview Questions And Answers
Top OCI Questions
☺ | What is database normalization? |
☺ | What is the main difference between foreign key and primary key? |
☺ | Tell me in function why return single value? |
☺ | What is difference between SQL Server and Oracle? |
☺ | Can we use a having clause in groupby clause? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |