How a database CASE tool works?
Once you create a data model (Entity-Relationship Diagram) using one of the data modeling SW tools, that is almost the end of development because the modeling SW tool check errors, generate a physical model, and also generate actual line of codes of database automatically.
Below pictures show the creation of database from the model to actual line of codes.