Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.
For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email email@example.com.
You can use reverse engineering feature of the CASE tool you use to get the diagram, though i don’t see any practical advantage of having such a diagram ‘cause right now database is used more like a storage, and almost everything is defined in configs. You can look into etc/config.xml of the module you are interested in if needed.