Data modeling is a technique to document a software device using entity partnership diagrams (ER Diagram) i beg your pardon is a depiction of the data frameworks in a table because that a company’s database. It is a very an effective expression of the company’s business requirements. Data models are supplied for numerous purposes, indigenous high-level theoretical models, logical to physics data models and also typically represented by the entity-relationship diagram. The serves together a overview used by database experts and software developers in the design and also implementation that a system and the underlining database.

You are watching: Difference between logical and physical database design

What is Entity relationship Diagram?

An Entity relationship Diagram (ERD) is a photographic representation that the info that deserve to be caught by a database. Such a “picture” serves 2 purposes. It permits database specialists to explain an overall style concisely however accurately. An er Diagram deserve to be easily transformed right into the relational schema. There room three contents in ERD: Entities, Attributes, and also Relationships.


ERD example – customer Appointment

Suppose we have actually the following company scenario:

One Customer may be making one or much more AppointmentsOne Appointment must be make by One and Only One CustomerThe cardinality attached from customer to Appointments is 0 come many


Edit this theoretical ERD

Conceptual ERD models the organization objects that must exist in a system and also the relationships between them. A conceptual model is arisen to present an overall snapshot of the mechanism by recognizing the organization objects involved. It specifies what reality exist, no which tables. Because that example, ‘many to many’ tables might exist in a reasonable or physical data model but they room just shown as a connection with no cardinality under the theoretical data model.

Conceptual data version example

NOTE: conceptual ERD supports the use of generalization in modeling the ‘a type of’ relationship in between two entities, for instance, Triangle, is a kind of Shape. The consumption is prefer generalization in UML. Notice that only conceptual ERD support generalization.

Logical data model

Logical ERD is a comprehensive version that a theoretical ERD. A reasonable ER model is developed to enrich a conceptual model by specifying explicitly the columns in every entity and introducing operational and transactional entities. Although a reasonable data model is quiet independent that the really database mechanism in which the database will be created, you can still take into consideration that if the affects the design.

See more: Do Mosquitoes Explode When You Flex, : Askscience

Logical data design example


Edit this physical ERD example


The key goal of a creating data model is come make particular that data objects readily available by the functional team are represented accurately. Us should first start indigenous the conceptual data model and as much more and more information available we add much more details to filter it from theoretical to the reasonable model. Finally, when we know exactly how to implement the database of our system, we deserve to refine our reasonable model into the physics data model which can straight map between the diagram and the actual database system.