Hi,
I have an application that I am building for an engineering company that would consist of the main departments, namely: Sales, Manufacturing, Installations, and Finance. A key function of this application is traceability between departments.
What would be the best practice in linking these department documentation together?
Scenario 1:
By creating a centralized table that contains the quote #, manufacturing #, installation #, invoice #, and status. Each department table updates the centralized table to keep track throughout the process.
Scenario 2:
Having one single table for all the mentioned departments. I foresee some problems with this solution.
Scenario 3:
Each department has its table referring to the previous department inside their department table and deploying by using views to combine the necessary data.
Do you have any suggestions or comments on the different scenarios? Perhaps even guides pertaining directly to the problem at hand.