UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Closed TopicStart new topic
> Normalizing A Database, Any Version    
 
   
NoahP
post Dec 8 2003, 06:04 PM
Post#1


Retired Moderator
Posts: 10,493
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!)
Attached File(s)
Attached File  343208.zip ( 4.3K )Number of downloads: 400
 
Go to the top of the page
 
Jerry Dennison
post Dec 9 2003, 11:45 AM
Post#2


Head Wizard
Posts: 14,857
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.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    12th December 2017 - 08:29 PM