There is a confusing multitude of tools written by Esri and others (some supported, some unsupported) for designing and diagramming a geodatabase.

Here is an attempt at creating a definitive list of where to find them.

Related to http://gis.stackexchange.com/questions/370/what-are-convenient-uml-tools-to-create-geodatabase-models/616#616