Groups > comp.databases.ms-sqlserver > #1690

Re: Is it really any point to have a relation in this example

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Is it really any point to have a relation in this example
Date	2014-02-19 21:13 +0100
Organization	Erland Sommarskog
Message-ID	<XnsA2D9D7EC34F93Yazorman@127.0.0.1> (permalink)
References	<le2d1u$ea1$1@dont-email.me>

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Is it really any point to have a relation in this example "Tony Johansson" <johansson.andersson@telia.com> - 2014-02-19 14:53 +0100
  Re: Is it really any point to have a relation in this example Erland Sommarskog <esquel@sommarskog.se> - 2014-02-19 21:13 +0100
    Re: Is it really any point to have a relation in this example rja.carnegie@gmail.com - 2014-02-19 13:43 -0800
  Re: Is it really any point to have a relation in this example Gene Wirchenko <genew@telus.net> - 2014-02-20 09:49 -0800

csiph-web