What is the difference between UML Data profile and ER model?

Question

I have been asked this question and even after a lot of research, I cannot find the answer.

When I design a database using Entity relationship (ER) and then re-draw it as UML class model (extended with Data modeling profile for UML), what are the differences and how both models can be (in their way) useful for db developer? With regard to multiplicity, foreign keys..

Answer 1

• UML class - model doesn't support views, stored procedures, triggers and databases elements. ER does.
• There is NO data modelling profile over class diagram in UML. look a search. It seams, it is a special feature of IBM, but they don't keep to UML.
• We can draw anything on the newly-invented diagram language. But what is the use of it? If you are really interested, study the pdf.