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

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

From	"Tony Johansson" <johansson.andersson@telia.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Is it really any point to have a relation in this example
Date	2014-02-19 14:53 +0100
Organization	A noiseless patient Spider
Message-ID	<le2d1u$ea1$1@dont-email.me> (permalink)

Show all headers | View raw

Assume that we have many products for example flowers but we have only one 
warehounse where we plant and store
these flowers.
So one Inventory has many flowers but one flower can only exist in one 
warehouse.

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.

//Tony

Back to comp.databases.ms-sqlserver | Previous | Next — 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