Results 1 to 2 of 2

Thread: Data Modeling

  1. #1
    Join Date
    Sep 2004
    Posts
    1

    Data Modeling

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by cruzmichael
    How to I handle the non-shared data objects among the four applications.
    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?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •