Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail From: "Tony Johansson" Newsgroups: comp.databases.ms-sqlserver Subject: Is it really any point to have a relation in this example Date: Wed, 19 Feb 2014 14:53:51 +0100 Organization: A noiseless patient Spider Lines: 15 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit Injection-Date: Wed, 19 Feb 2014 13:54:06 +0000 (UTC) Injection-Info: mx05.eternal-september.org; posting-host="8fdc2b5af81c338deb7045fc6c39b0e2"; logging-data="14657"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/h8hWjHct1n+ZBzA3IHnTb" X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18463 X-Newsreader: Microsoft Windows Mail 6.0.6002.18197 Cancel-Lock: sha1:oP/IYH2jogI79a11Nc6iwOwx1jU= X-Priority: 3 X-MSMail-Priority: Normal Xref: csiph.com comp.databases.ms-sqlserver:1689 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