Subject | WHICH ONE IS BETTER |
---|---|
Author | Ben Johnson |
Post date | 2002-02-16T02:01:18Z |
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.
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.