3 June 2008

Database Normalization and Table structures

Posted by Mikhail Esteves under: Links .

Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal Form), 3NF (Third Normal Form) and BCNF (Boyce-Codd Normal Form). There are others but they are rarely if ever used. A database is said to be Normalised if it is in 3NF (or ideally in BCNF). These steps are descibed as follows:

Read more



One Comment so far...

Recent URLs tagged Normalization - Urlrecorder Says:

23 September 2008 at 10:32 pm.

[…] Recent public urls tagged “normalization” → Database Normalization and Table structures […]

Leave a Reply

Browse

Photography

Projects

Pages

Calendar

June 2008
M T W T F S S
« May   Jul »
 1
2345678
9101112131415
16171819202122
23242526272829
30  

Categories

www.flickr.com

Use OpenDNS