How to decide whether to use ER or UML for modelling?

database database-design uml er-diagrams
stallion picture stallion · Nov 7, 2012 · Viewed 23.2k times · Source

A UML diagram can be used both to model database designs and class designs, but an ER diagram should be used exclusively in database problems. How do you pick one graphical representation over the other?

Answer

ilansch picture ilansch · Nov 7, 2012

ERD - Entity Relation Diagram - giving you image of how the tables should connect, what fields are going to be on each table, the tables connection, if many-to-many, one-to-many.

UML can be used for many diagrams other then ERD. sequence diagram, state diagram, more for the funcionality of the application (what user can do, who does it, when he does it, before what step, what table he use to do it) other then the tables description.

I Would use ERD to describe database relation and UML to describe operations, time, actions, etc..

Refer wiki : Entity-relationship_diagram & Unified_Modeling_Language

Related questions

Display primary : foreign key relationships in Visio database diagram

I've created a Database Model relationship diagram in Visio with tables and relationships. However, I can't find any way to automatically display the Primary Key :: Foreign Key relationship in the diagram. The only workaround I can find is to insert …

Read More
Multiplicity vs Cardinality

When talking about data models and databases, the term Cardinality is often used to describe the number of allowed elements in a given set. UML often refers to the same property as Multiplicity. Is there any differences between these two …

Read More
How do I add multiplicity values in StarUML

I am studying Database Development and I am at the stage where I have to create my own ER Models. Everything is fine so far with StarUML however the course notes don't mention how to add muliplicity options between entity …

Read More