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@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 - 13:21:11 CDT