Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
When do you split into separate tables?
Message
From
24/10/2001 18:18:33
 
 
To
24/10/2001 18:06:57
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00572907
Message ID:
00572939
Views:
24
>Steve-
>
>I appreciate you voicing your views. I've read a lot on "Data Normalization" and I guess I wanted to here the views of FoxPro programmers on the UT.
>
>One pitfall I would like to avoid is over-normalization. The two symptoms of over-normilization I have found is too complicated and too slow.
>
>That may not be the case here but if I'm going to raise the level of complexity, I better have a good reason.
>
>Higher complexity usually equates to increased maintenance hours.
>

Dan,

Proper normalization is more flexible, I think. I also think it leads to lower maintenance. Making changes to a table will have fewer unexpected side effects, because each table has a clear purpose.

I hope others chime in, too. I think it is an interesting topic of discussion.
Steve Gibson
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform