9.8 Converting a UML Diagram to an Object-Relational (OR) Database Model

The UML diagram for the revised University example shown in Figure 9.5 mapped directly to both the ODL schema in Figure 9.6 and to the Iris schema shown in Figure 9.8. ORDBMSs are limited in their ability to express all of the semantic information in a UML diagram, but the basic elements of classes, hierarchies, and relationships are easily represented using the OO features of an ORDBMS such as Oracle.

For each class in a UML diagram, we create a UDT, which can include single attributes of the class using built-in data types, user defined types, structured attributes using nested UDTs, multivalued attributes using arrays, and multivalued structured attributes using nested ...

Get Databases Illuminated, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.