HOWTO: company & client addresses 1 or 2 tables?
From: Niels van der Kam <n.a.van.der.kam_at_home.nl>
Date: Mon, 9 Jun 2003 20:21:11 +0200
Message-ID: <bc2j6t$ttg$1_at_news2.tilbu1.nb.home.nl>
Hi,
Date: Mon, 9 Jun 2003 20:21:11 +0200
Message-ID: <bc2j6t$ttg$1_at_news2.tilbu1.nb.home.nl>
Hi,
I've got a question about the design of a database.
I've got two tables: one with company information and one with client information. A client can be part of a company (the client has a Company_ID field) or be on his own. The client and the company both have 1 or more addresses. Now here's my question.
Should I make one table which can contain both company and client addresses
in one? This table I give two field, Client_ID and Company_ID of which one
of both gets filled.
Or should I make two tables one for company addresses and one for client
addresses?
Are there rules for this kind of situations?
Thanks,
Niels Received on Mon Jun 09 2003 - 20:21:11 CEST