We have designed database structures for a variety of projects. We typically use an object-modeling tool to generate an object model, and then a database modeling tool to generate the logical and physical data models and the Entity Relationship Diagram.