Date of Award


Publication Type

Master Thesis

Degree Name



Computer Science

First Advisor

Li, Liwu,


Computer Science.




Database Reverse Engineering (DBRE) refers to mapping relational schemas into semantically enriched models. Most of researches on DBRE map relational databases into the ER or EER models. They differ in input requirements and output. Unlike previous DBRE approaches, this thesis provides a methodology for mapping relational databases into an object-oriented designs in the UML. A distinct advantage of our approach is that it unifies objected oriented application designs and relational database designs. In this thesis, we first provide the Unified Modeling Language (UML) representations for basic relation schemas, with rigorous definitions for relational model concepts given by the UML metamodel and Object Constraint Language (OCL). Then, the paper classifies relational databases based on the types and number of inclusion dependencies. Finally, a general approach for mapping relational databases into object-oriented designs in the UML is specified.Dept. of Computer Science. Paper copy at Leddy Library: Theses & Major Papers - Basement, West Bldg. / Call Number: Thesis2001 .Z53. Source: Masters Abstracts International, Volume: 40-06, page: 1562. Adviser: Liwu Li. Thesis (M.Sc.)--University of Windsor (Canada), 2001.