In this section i would like to give you example of Logical data modeling techniques with some of the important steps.The physical data model is more detailed representation of the database. These are some most important reasons of using the Logical data modeling techniques.The basic reason for using the logical data modeling is to avoid the complexity in physical data structure.The physical data structure will make more complex query than logicalĭata structure if you practically test it. Its better to work on simple Logical model rather than the complex physical data model. The Logical data modeling provides the way of reusing the data in proper way.ĥ.Decreasing Development and maintenance cost : The Logical data modeling helps in foundation of complex database design. The logical data model is very useful for understanding different business requirements in easy way. There are so many physical data structure which are really very complex to handle.When user wants to handle the complex relationship between data entities the Data model is very useful.Ģ.Understanding the Business requirements : Why Logical Data Model?Įveryone have question in mind that Why user needs to convert the physical data model in to logical data model.In this section i will explain the different reasons for using the Logical data model. These are above some most important features of data modeling.Logical data modeling is not providing the information about structure to be implemented.It will give you information related to the logical structure of the database. User needs to specify the database normalization and needs to use the normalization. User needs to specify all attributes for Each and every entity using in the data model. User needs to define the foreign key to specify the relationship between the two or more entities. User needs to define the primary key for each entity specified in the model. The Logical Data Model Should include all entities in specified database with its relationship.
![navicat data modeler logical to physical navicat data modeler logical to physical](https://imgs.developpaper.com/imgs/2020010821385259.jpg)
This concept is mainly used in Business processes which will capture the information about organization.The concept is used in reporting purpose and development of RPD purpose in OBIEE like Business Intelligence applications.In this section i would like to explain about the different features of Logical Data Modeling.ġ.Include all Entities and Relationships : Different Features of Logical Data Modeling : Logical Data Model is nothing but the detailed structure of database. There are so many different concepts that user needs to understand regarding Logical Data Model.The logical data model always represents the physical data architecture of the database.The logical data modeling gives us information about all the entities with relationship between those entities present in database. The Logical data modelinf is nothing but the logical representation of the database to achieve the specific purpose. In my previous article I have given the basic idea about the Dimensional data modeling.In this article i would like to explain the concept of Logical Data Model with real life examples.I want to focus on some important examples of Logical Data Model.