Identifying extended entity-relationship object structures in relational schemas
Victor M Markowitz, Johann A. Makowsky · IEEE Transactions on Software Engineering · 1990
Relational schemas consisting of relation-schemes, key dependencies and key-based inclusion dependencies (referential integrity constraints) are considered. Schemas of this form are said to be entity-relationship (EER)-convertible if they can be associated with an EER schema. A procedure that determines whether a relational schema is EER-convertible is developed. A normal form is proposed for relational schemas representing EER object structures. For EER-convertible relational schemas, the corresponding normalization procedure is presented. The procedures can be used for analyzing the semantics of existing relational databases and for converting relational database schemas into object-oriented database schemas.>
Cited by 152 works. doi:10.1109/32.57618 Open-access PDF
Authors
References
- The Entity Relationship Model — Toward a Unified View of Data
- The entity-relationship model—toward a unified view of data
- Extending the database relational model to capture more meaning
- Extending the data base relational model to capture more meaning
- Principles of Database Systems
- Semantic database modeling: survey, applications, and research issues
- A logical design methodology for relational databases using the extended entity-relationship model
- Object identity
- Advances in computing research
- Object identity