Identifying extended entity-relationship object structures in relational schemas

1 January 1990

journal article
Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Transactions on Software Engineering

Vol. 16 (8) , 777-790
https://doi.org/10.1109/32.57618

Abstract

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.

Keywords

This publication has 14 references indexed in Scilit:

A normal form object-oriented entity relationship diagram
Published by Springer Nature ,1994
On the correctness of representing extended entity-relationship structures in the relational model
Published by Association for Computing Machinery (ACM) ,1989
Semantic database modeling: survey, applications, and research issues
ACM Computing Surveys, 1987
Entity-relationship consistency for relational schemas
Published by Springer Nature ,1986
Object identity
Published by Association for Computing Machinery (ACM) ,1986
Relative information capacity of simple relational database schemata
Published by Association for Computing Machinery (ACM) ,1984
Mapping Uninterpreted Schemes into Entity-Relationship Diagrams: Two Applications to Conceptual Schema Design
IBM Journal of Research and Development, 1984
Entity-relationship diagrams which are in BCNF
International Journal of Parallel Programming, 1983
Extending the database relational model to capture more meaning
ACM Transactions on Database Systems, 1979
The entity-relationship model—toward a unified view of data
ACM Transactions on Database Systems, 1976