I have a question regarding an application I want to develop for my work. We are an engineering company and I want to make like a project manager, organizer and parts list for our projects.
For the first part of my application I will have data of clients, employees, contact persons for each client with all their information. Also I will have a list of my projects which will contain every information regarding clients, who worked and how much, when was it delivered and so on.
For all these I am using a single database with tables for each element.
NOW, there are approximately 300 to maybe 600 projects in one year. For each project I want to create a list of parts which are very many and in many categories like screws, sensors, pneumatics, electrics and so on. They will also contain prices, suppliers, etc... so it will be pretty complex.
My question is: how would it be best to work? I was thinking that it would be best if every project has it's separate database. But can I create databases at runtime? By doing this would it be safer for backups and stuff like that? I was wondering what would be the best way to manage all these projects and databases? Thank you.
I am using VB2010 express and SQL Server 2008R2.