Information Systems, Databases, and Models › Modeling Architecture

Modeling Architecture

Five modeling levels are presented in the following illustration. Notice that the DBMS model can be at either an Area Level scope, or a Project Level scope. It is not uncommon to have single ERD and KB models for a business, and multiple DBMS models. You can have one DBMS model for each implementation environment, and another set within that environment for projects that do not share databases. In an ideal situation, there is a set of Area Level scope DBMS models. One Area Level scope DBMS model for each environment, with complete data sharing across all projects in that environment.

The models fall into two categories:

• Logical
• Physical