Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


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

More about relationship in a database

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 More about relationship in a database
Date Sun, 16 Feb 2014 18:26:35 +0100
Organization A noiseless patient Spider
Lines 7
Message-ID <ldqsci$ths$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 Sun, 16 Feb 2014 17:26:42 +0000 (UTC)
Injection-Info mx05.eternal-september.org; posting-host="8fdc2b5af81c338deb7045fc6c39b0e2"; logging-data="30268"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+U+60YUcfAwmPsF9RUwRKT"
X-MimeOLE Produced By Microsoft MimeOLE V6.0.6002.18463
X-Newsreader Microsoft Windows Mail 6.0.6002.18197
Cancel-Lock sha1:+flrkvuaSU/y0bZ7h+LR4XtIyO4=
X-Priority 3
X-MSMail-Priority Normal
Xref csiph.com comp.databases.ms-sqlserver:1685

Show key headers only | View raw


Assume I have a table in the database called Inventory.
Now what is a resonable design type between Inventory and Product.
Where should the foreign key be placed ?

//Tony

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


Thread

More about relationship in a database "Tony Johansson" <johansson.andersson@telia.com> - 2014-02-16 18:26 +0100
  Re: More about relationship in a database Erland Sommarskog <esquel@sommarskog.se> - 2014-02-16 19:42 +0100

csiph-web