Re: 1 table many fields/several tables less fields?

2002-03-25 Thread Paul DuBois
At 21:34 + 3/25/02, Gath wrote: >Greetings. I would thank some feedback on this issue. The doubt is: >Should i create a table, with about 40-65 fields (ID, 3 or 4 of text, the >reamining of small/tiny int), or should i split it in about 4-6 tables, >dividing the fields between them? >Info: >Th

RE: 1 table many fields/several tables less fields?

2002-03-25 Thread Land, Christopher
Here are the 5 Rules of Data Normalization -- http://www.datamodel.org/NormalizationRules.html Eliminate Repeating Groups - Make a separate table for each set of related attributes, and give each table a primary key. Eliminate Redundant Data - If an attribute depends on only p