Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1690
| 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 | 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 | Wed, 19 Feb 2014 21:13:33 +0100 |
| Organization | Erland Sommarskog |
| Lines | 18 |
| Message-ID | <XnsA2D9D7EC34F93Yazorman@127.0.0.1> (permalink) |
| References | <le2d1u$ea1$1@dont-email.me> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=windows-1252 |
| Content-Transfer-Encoding | 8bit |
| Injection-Info | mx05.eternal-september.org; posting-host="fd3d6d0229f14a752f017d8f9903addd"; logging-data="25890"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+c+RjDBEyuh1Y1ZAGswANZ" |
| User-Agent | Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) |
| Cancel-Lock | sha1:TptH/nig9Ilij0dy+NGhXyCXNBY= |
| Xref | csiph.com comp.databases.ms-sqlserver:1690 |
Show key headers only | 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
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