bnickelsen
03-30-2005, 12:27 PM
I need to build a database or databases!!!
The question I present here, should I build one database or break it down into several databases.
The Uses:
We provide a service that includes labor and material. But first we estimate what will be needed. Then a sales person attempts to sell it. If we sell it a group of people go out and perform the service.
So the database(s) needs to track the requests for the estimates, be used to build the estimates, be used by the salespeople to build presentation to help them sell the service. And finally be use to track the progress of the service.
I was all set to build 2, 3 or even more databases but it hit me that at least one table would be repeated in each case, employees.
The only other consideration is the need to limit access to certain parts. For example a Salesperson can not change the estimate details.
The question I present here, should I build one database or break it down into several databases.
The Uses:
We provide a service that includes labor and material. But first we estimate what will be needed. Then a sales person attempts to sell it. If we sell it a group of people go out and perform the service.
So the database(s) needs to track the requests for the estimates, be used to build the estimates, be used by the salespeople to build presentation to help them sell the service. And finally be use to track the progress of the service.
I was all set to build 2, 3 or even more databases but it hit me that at least one table would be repeated in each case, employees.
The only other consideration is the need to limit access to certain parts. For example a Salesperson can not change the estimate details.