Normalizing A Database, Any Version
Dec 8 2003, 06:04 PM
Joined: 12-January 01
From: Lexington/Louisville KY USA
I posted this recently in response to another poster's request, and hope that it can help you work through the process of normalizing your table structure.
(Thanks Jerry Dennison for pointing out the need of a PartsPrice table!)
343208.zip ( 4.3K )Number of downloads: 347
Dec 9 2003, 11:45 AM
Joined: 31-January 00
From: South Carolina, USA
It isn't necessary to have both the PartID and PartPriceID FK's in tblOrderLineItems. You need only the PartPriceID. By including both, you've created a circular join.
|Search Top Lo-Fi||28th March 2017 - 05:07 AM|