Re: schema question

On Sat, 18 Nov 2000, Clark Snowdall wrote:

> I have a quick question to pose regarding database theory. Imagine if
> you will a company that needs to keep track of 1 million users' address
> books. Is it best to:
 

> 1) Have a master table listing all the users' principle information
> [...] and then also have another table listing all of their address
> entries.
 

> OR 2) Again have a master table listing all the users' principle
> information, but instead have a new table for each user that only
> lists the address book entries for that user.

Definitely #1. A DBMS should be able to handle this efficiently.

   Simon

-- 
GPG public key available from http://phobos.fs.tum.de/pgp/Simon.Richter.asc
 Fingerprint: DC26 EB8D 1F35 4F44 2934  7583 DBB6 F98D 9198 3292
Hi! I'm a .signature virus! Copy me into your ~/.signature to help me spread!