We have four individual applications for Immigration, Labor, Citizen Registration System (like the Social Security System in the US) and Traffic and Licensing Department. All these 4 applications have individual databases. I have come up with a 3rd Normalized Form Logical Data Model for each one of the applications. I have to merge these 4 Data Models into one master Data Model. I have created a single data model for all the shared objects between the four applications (IMM, LAB, CRS and TLD). How to I handle the non-shared data objects among the four applications.



I will appreciate your feedback.



Many Thanks,

Cruz

i would simply add them to the model

the thing about a logical data model is that it's logical

it says nothing about how the physical tables to implement the model's
entities will be partitioned into separate databases

so even if you end up with a "shared" (common) database, as well as
separate databases for the separate applications, you would still have
everything included in the overall global data model

helps?