What are different normalization forms?

What are different normalization forms?

What are different normalization forms?

View Answers

November 18, 2010 at 4:57 PM

Hi,

1NF: Eliminate Repeating Groups- Make a separate table for each set of related attributes, and give each table a primary key. Each field contains at most one value from its attribute domain.

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. All attributes must be directly dependent on the primary key

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.

Thanks,









Related Tutorials/Questions & Answers:
What are different normalization forms?
What is normalization?
Advertisements
Normalization
What are the different types of AutoProxying?
ModuleNotFoundError: No module named 'forms2'
ModuleNotFoundError: No module named 'forms2'
WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP?
What are the different functions in sorting an array?
What are different environments to configure hibernate?
What are the different modules in Spring framework?
with a different number, what’s the problem
with a different number, what’s the problem
what are different M.I.S reporting tools basically used?
What are the different types of property and class mappings?
what are different M.I.S reporting tools basically used?
What is a join and explain different types of joins
What are constructors ? explain different types of constructor with example
Explain normalization concept?
ModuleNotFoundError: No module named 'normalization'
ModuleNotFoundError: No module named 'normalization'
Data Normalization
keeps coming up with a different number, what’s the problem.
keeps coming up with a different number, what’s the problem
Database Normalization
What are the different types of interfaces in java? - Java Interview Questions
ModuleNotFoundError: No module named 'data-normalization'
ModuleNotFoundError: No module named 'data-normalization'
ModuleNotFoundError: No module named 'pyfb-normalization'
ModuleNotFoundError: No module named 'radiometric_normalization'
ModuleNotFoundError: No module named 'text-normalization'
ModuleNotFoundError: No module named 'data-normalization'
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what’s the problem?
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what’s the problem?
ModuleNotFoundError: No module named 'dl-spectral-normalization'
ModuleNotFoundError: No module named 'torch-layer-normalization'
ModuleNotFoundError: No module named 'torch-layer-normalization'
ModuleNotFoundError: No module named 'dl-spectral-normalization'
ModuleNotFoundError: No module named 'keras-layer-normalization'
JAVA what is different between static block and public static void main(String a[]) method
Different JRE
What is a database?
different kinds of actions in Struts
different JDBC drivers available
What is Commercial Fleet Management?
Know the Different Types of E-Commerce
Different between getRequestParameterMap() and getRequestParameterValuesMap()
DIFFERENT PAGES FOR DIFFERENT USERS ACCORDING TO THEIR ROLE
ftech different value corresponding different value
different between ntfs and fat
links with different colors.

Ads