Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Simple Denormalized vs Normalized Example
Message
 
À
23/12/1999 18:36:43
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00308138
Message ID:
00308329
Vues:
25
>I could be way off base here, but I don't consider this denormalization at all. Denormalization is when the same piece of information is stored in two places. IN the example you showed, the effective rate for the call, and the current rate are not the same piece of information, but two distinctly different concepts. If the values can vary independently, you have not denormalized, you have only created as many fields as you need to accurately reflect the state of things.

Erik,

Execellent, and you have NORMALIZED the database.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform