[BiO BB] RE: Normalization WAS: database design question

JRambla jrambla at hotmail.com
Tue Mar 2 04:28:30 EST 2004


Hi all,

Normalization is a concept that comes from relational database theory,
created by the recently deceased Dr.Edgar F. Codd, a mathematician at IBM.
That theory is the base of all SQL-whatever world.

Normalization is a group of rules (5, if my memory is right) to apply to
table design in order, basically, to eliminate redundancy on data. That
redundancy will arise in the form of embarrassing, and sometimes hard to
find, consistency problems on data stored in the database.

As was suggested, following those rules is a good starting point to design a
database.

You can find a good introduction in

http://www.sequoia.be/consult/method/english.htm

Hope this helps,

Jordi Rambla
Barcelona (Spain)

-----Mensaje original-----
De: bio_bulletin_board-admin at bioinformatics.org
[mailto:bio_bulletin_board-admin at bioinformatics.org] En nombre de Svensson,
B.A.T. (HKG)
Enviado el: martes, 02 de marzo de 2004 2:13
Para: 'bio_bulletin_board at bioinformatics.org '
Asunto: [BiO BB] RE: Normalization WAS: database design question

> Normalization is the process of designing a good data model.

Please, explain this statement.
_______________________________________________
BiO_Bulletin_Board maillist  -  BiO_Bulletin_Board at bioinformatics.org
https://bioinformatics.org/mailman/listinfo/bio_bulletin_board



More information about the BBB mailing list