Skip to Main Content
Databases Illuminated, 4th Edition
book

Databases Illuminated, 4th Edition

by Catherine M. Ricardo, Susan D. Urban, Karen C. Davis
March 2022
Intermediate to advanced content levelIntermediate to advanced
682 pages
22h 58m
English
Jones & Bartlett Learning
Content preview from Databases Illuminated, 4th Edition

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL and Relational Theory, 3rd Edition

SQL and Relational Theory, 3rd Edition

C.J. Date

Publisher Resources

ISBN: 9781284231595