Database objects are represented in Unified Modeling Language (UML) class diagram views based on the defined mapping between database elements and UML diagram elements.
The following table illustrates how relational database (RDB) elements map to UML elements and stereotypes with icons in UML class diagrams. A stereotype is an extension mechanism that broadens the vocabulary of UML and gives more specific meaning to a database element.
RDB element | UML element | Stereotype | Icon |
---|---|---|---|
Database | Component | <<Database>> | ![]() |
Schema | Schema | <<Schema>> | ![]() |
View | Class | <<Database View>> | ![]() |
Table | Class | <<Table>> | ![]() |
Column | Attribute | <<Column>> | ![]() |
Stored procedure | Operation | <<Stored Procedure>> | ![]() |
User-defined function | Operation | <<User Defined Function>> | ![]() |
Java™ Database Connectivity (JDBC) connection | Component | <<Connection>> | ![]() |