Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Revisiting Normal Forms
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00159608
Message ID:
00159760
Views:
25
Mark,

I would propose to you that in fact your data designs are fully normalized. The product description in the invoice line table is NOT the same data as the one in the inventory table, so you do not have duplicate data. The inventory table has the CURRENT description and the invoice line table has the description at the TIME of the invoice. The same for the tax stuff.
Previous
Reply
Map
View

Click here to load this message in the networking platform