Question

How would you describe some of the ER design limitations, and discuss how understanding these limitations will influence how you choose to model a particular situation so that you are able to represent the things that are most important?

Answer 1

Some of the ER design limitations.

* loss of information: Some information or data be lost or hidden in the ER model

* most used high-level design: ER model is very popular for designing high-level design

* no representation of data manipulation: data manipulation information is hard to show or display in the ER model or diagram.

* no standards: many versions that can be confusing, when we use the different constraint for the same versions

* limited relationship representation: ER model represents the limited relationship as compared to other data models like the relational model etc.

* relational databases: The ER design used widely for relational databases.

So by the above points:

• it is best practice to complete ER modeling before implementing your database.
• Make effective use of colors. so that you can use colors to classify similar entities or to highlight the main areas in your diagrams.
• Achieve the maximum useful possible through customizations
• Use well-named convention to build a well-structured schema
• Remove redundant, or unnecessary relationships between entities to avoid confusion between entities.