Cameo Data Modeler provides SQL Diagram, a specialized diagram for database modeling that enables you to create and depict various SQL elements. It is located under the Data Modeling diagram subgroup.
In addition to the main SQL diagram, there is a slightly modified diagram for Oracle databases, Oracle SQL Diagram. It is located under the same Data Modeling diagram subgroup. This diagram is only slightly modified. It has an additional diagram button for Materialized View modeling. Other than that, it is identical to the main SQL diagram. If you are not modeling materialized views, you can freely use the generic diagram type instead of the specialized one for Oracle modeling.
Once you apply the Cameo Data Modeler plugin to MagicDraw, you can display the crow’s foot notation or use standard UML notation of associations (displaying multiplicities in text format) in the SQL diagram.
To display Multiplicities or crow’s foot notation in a SQL diagram