What is normalization and types of normalization?

Answer Posted / j geor

Database normalization is a technique for designing
relational database tables to minimize duplication of
information and, in so doing, to safeguard the database
against certain types of logical or structural problems,
namely data anomalies.
1NF Eliminate Repeating Groups - Make a separate table for
each set of related attributes, and give each table a
primary key.
2NF Eliminate Redundant Data - If an attribute depends on
only part of a multi-valued key, remove it to a separate table.
3NF Eliminate Columns Not Dependent On Key - If attributes
do not contribute to a description of the key, remove them
to a separate table.
BCNF Boyce-Codd Normal Form - If there are non-trivial
dependencies between candidate key attributes, separate them
out into distinct tables.
4NF Isolate Independent Multiple Relationships - No table
may contain two or more 1:n or n:m relationships that are
not directly related.
5NF Isolate Semantically Related Multiple Relationships -
There may be practical constrains on information that
justify separating logically related many-to-many relationships.
ONF Optimal Normal Form - a model limited to only simple
(elemental) facts, as expressed in Object Role Model notation.
DKNF Domain-Key Normal Form - a model free from all
modification anomalies.

Is This Answer Correct ?    165 Yes 29 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the uses of sysdate and user keywords?

871


What is difference between group by and partition by?

722


What is the difference between in and between in sql?

804


What are the benefits of pl/sql packages?

774


Write a sql query to convert all character to uppercase after hypen.

1198


how to select first 5 records from a table? : Sql dba

718


what is the difference between myisam static and myisam dynamic? : Sql dba

805


What is vector point function?

799


What is a file delimiter?

772


Does sap use sql?

735


What is the difference between stored procedure and view?

788


What does the argument [or replace] do?

833


What is row_number () in sql?

758


Explain raise_application_error.

854


Does truncate remove indexes?

750