Reverse engineering of relational databases: Extraction of an EER model from a relational database

RHL Chiang, TM Barron, VC Storey - Data & knowledge engineering, 1994 - Elsevier
A methodology for extracting an extended Entity-Relationship (EER) model from a relational
database is presented. Through a combination of data schema and data instance analysis,
an EER model is derived which is semantically richer and more comprehensible for
maintenance and design purposes than the original database. Classification schemes for
relations and attributes necessary for the EER model extraction are derived and justified.
These have been demonstrated to be implementable in a knowledge-based system; a …