Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What is normalization? What are different types of normalization
What is normalization? What are different types of normalization?
✍: Guest
It is set of rules that have been established to aid in the design of tables that are meant to
be connected through relationships. This set of rules is known as Normalization.
Benefits of normalizing your database will include:
1. Avoiding repetitive entries
2. Reducing required storage space
3. Preventing the need to restructure existing tables to accommodate new data.
4. Increased speed and flexibility of queries, sorts, and summaries.
Following are the three normal forms
First Normal Form
For a table to be in first normal form, data must be broken up into the smallest units
possible.In addition to breaking data up into the smallest meaningful values, tables in
first normal form should not contain repetitions groups of fields.
For in the above example city1 and city2 are repeating.In order that this table to be in
First normal form you have to modify the table structure as follows.Also not that the
Customer Name is now broken down to first name and last name (First normal form data
should be broken down to smallest unit).
Second Normal form
The second normal form states that each field in a multiple field primary keytable must
be directly related to the entire primary key. Or in other words, each non-key field should
be a fact about all the fields in the primary key.
In the above table of customer, city is not linked to any primary field.
That takes our database to a second normal form.
Third normal form
A non-key field should not depend on other Non-key field. The field "Total" is dependent
on "Unit price" and "qty".
So now the "Total" field is removed and is multiplication of Unit price * Qty.
Note :- Fourth and Fifth normal form is left as a home work to users.
2007-10-25, 6897👍, 0💬
Popular Posts:
What is CMM and different levels? explain? The Capability Maturity Model (CMM) is a process capabili...
How can I implement a variable field width with printf? That is, instead of something like %8d, I wa...
Do events have return type ? No, events do not have return type.
when should the volatile modifier be used? The volatile modifier is a directive to the compiler's op...
How To Enter Binary Numbers in SQL Statements? - MySQL FAQs - Introduction to SQL Basics If you want...