Subject WHICH ONE IS BETTER
Author Ben Johnson
Hi,

I am planning to develop an application for a tax consultancy firm. This firm has around 240 customers
and this may go upto a maximum of 400.

So each customers account has to be kept seperately for each financial year. This application requires only
20 tables.

What I want to know is how to design the database? Do I have to keep seperate database for each customer?
Or using a single database and identifying each customers transactions based on customer code? Which one
is better? Pls help.

Thanks in advance.

Ben.