From: esquel@sommarskog.se   
      
   Tony Johansson (johansson.andersson@telia.com) writes:   
   > In this example is it any point to create a separate table for warehouse.   
   > Is it just as good to store information such as current quantity for each   
   > flower that exist in the product table.   
   >   
   > I find it funny to have a table warehouse with just an Id without any more   
   > fields.   
      
   Most likely the warehouse have other attributes like name, address, etc.   
      
   But even we assume something that only has an ID, which in this case must   
   be a natural key, it should probably be a separate table, as a foreign-key   
   constraint to this table helps to restrict the possible values in the   
   column.   
      
      
   --   
   Erland Sommarskog, Stockholm, esquel@sommarskog.se   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)