Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simple Denormalized vs Normalized Example
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00308138
Message ID:
00308334
Views:
23
>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".
Previous
Reply
Map
View

Click here to load this message in the networking platform