What Is Logical Data And Physical Data In Databases?
In Databases Logical data and the Physical data are the data models. Both have different features. Logical data gives the graphical representation. It includes all entities, tables and relationships. It gives all of the information about attributes,columns and fields. The primary key is mentioned for each entity. There are foreign keys which identify the relationship between different entities. Normalization also occurs in logical data. In a logical data model, unlike physical data, the data modeler attempts to give more details about the data. In the physical data, tables, stored procedures, domains, columns, keys, and data types are included. Moreover, it also gives validation rules, database triggers and access constraints. In this case foreign keys are used for identification of relationships between tables. In physical data demoralization occurs. Because of physical considerations, this model is very different from the other models. In this model unlike logical data, modeler speci
