Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Simple Denormalized vs Normalized Example
Message
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:
00308334
Vues:
22
>Just like I have to store the Product Description in the InvoiceDetails table instead of relying on the current description in the Inventory table. Why? Because their distributors are constantly tweaking the descriptions. Sometimes they even change the size without creating a new item number. Wreaks havoc on their inventory control.

Mark,

Again, not a violation of normalization. The two descriptions are NOT the same data. One is "at the time of the transaction" and the other is "current description".
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform