Getting started Data Modeling

[jdbussel]

Trying to get started doing data modeling and have been looking for some tutorials or documentation.  If anyone could direct me to some, I would greatly appreciate it.

Also, a specific question, does EA allow the creation of a Logical data model that can be applied to a physical model, but have components that are only visible in a logical model?  Table relationships is what I had in mind, don't want to build all RI components, but want documentation in a logical model of what connects.

Thx,
JB

[qwerty]

You can perform a transformation from a logical to a physical data model. I have no great plan of data modeling but there's an add-in available from Sparx Japan which supports data modeling (can't recall the name of the product, but it should be somewhere on Sparx site [edit: see last link down in skiwi's post).

q.

[skiwi]

http://www.sparxsystems.com/enterprise_architect_user_guide/9.3/domain_based_models/datamodelling2.html

http://www.sparxsystems.com/resources/uml_datamodel.html

http://www.sparxsystems.com/downloads/whitepapers/Database_Modeling_In_UML.pdf

http://www.dbmode.com/

[Dermot]

The data modeling whitepaper on the community site covers this scenario of generating Physical (DB specific) model from the Logical model - see:
http://community.sparxsystems.com/white-papers/669-data-modeling-from-conceptual-model-to-dbms

There are also templates for reversing this on:
http://community.sparxsystems.com/community-resources/512-84data-modeling-logical-and-conceptual-mda-transforms