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: 341
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||23rd February 2017 - 08:33 PM|