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

[Svensson, B.A.T. (HKG)]

Thank u for you suggested readings, but I did seek an elaboration on
why (high/er?) normalization should be regarded as a good design?

-----Original Message-----
From: JRambla
To: bio_bulletin_board at bioinformatics.org
Sent: 2004-03-02 10:28
Subject: RE: [BiO BB] RE: Normalization WAS: database design question

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
_______________________________________________
BiO_Bulletin_Board maillist  -  BiO_Bulletin_Board at bioinformatics.org
https://bioinformatics.org/mailman/listinfo/bio_bulletin_board