Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1689
| 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" <johansson.andersson@telia.com> |
| 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 | <le2d1u$ea1$1@dont-email.me> (permalink) |
| 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 |
Show key headers only | 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
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