What are the benefits or disadvantages of ER diagrams

What are the benefits or disadvantages of ER diagrams

Answer:

Benefits and Disadvantages of ER Diagrams
  • Conceptual simplicity. If relationships between entities and attributes are known, an ERD can be quickly drawn.
  • Explicit visual representation. The database structure can be easily comprehended after consulting the diagram.
  • Communication effectiveness.
  • Immense flexibility.

buy cheap nursing papers here

The main difference between Logical and Physical Data Model is that Logical data models help to define the data elements and their relationships, while the physical data models help to design the actual database based on the requirements gathered during the logical data modelling.

The logical design goal is to design an enterprise-wide database based on a specific data model but independent of physical-level details. Logical design requires that all objects in the conceptual model be mapped to the specific constructs used by the selected database model.

Question:

What are the benefits or disadvantages of ER diagrams? Why bother with logical design and not just create tables andcolumns (physical design) directly?

Scroll to Top