A little premature normalization (syntax, form) is possible.
Based on your names and comments,
it looks like we have a good deal of updating
Shoes.PCity when a Producer moves.
Lets make a table Producer(ID, City), removing PCity from Shoes,
keeping Shoes.PID (or Shoes.Producer_ID, seems more readable) as a
foreign key to 'Producer'.

Still, the questions to be answered first are about
pragmatics and semantics,
/use/ and /meaning/ :
What do I need it for?
What does it mean?
Received on Tue Oct 02 2007 - 09:19:21 CEST