Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Store, or generate values?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00427625
Message ID:
00428956
Views:
27
>There are no factors that would indicate that one should NOT normalize their database design.
>
>All relational database designs should be normalized fully. The issue is not whether to normalize or not, it is what to do after you have a fully normalized database design. The process of normalization (which is often given a bad reputation by folks who aren't completely clear on exactly what normalization is) optimizes a data design for data entry and updating and reduces the possibilities and likelihood of update and insert anomalies at the cost of possibly reducing performance on data retrieval. Normalization also discovers certain design errors that would go unnoticed if the normalization was not done.
>
>Once a fully normalized design is reached one needs to evaluate the functional requirements of the system being designed and then decide if and how far to back off from the fully normalized design to provide an acceptable data retrieval performance.

I like this. This is the way I generally work, but I'd never heard that that's what you were supposed to do.

Thanks for the info.
-cjh
Previous
Reply
Map
View

Click here to load this message in the networking platform