A practical approach to transforming extended ER diagrams into the relational model

Constructs for hextended JZR model are defined and classified as a basis for transformation into the relational model. Transformation rules are developed for the different possible forms of n-ary relationships among entities including relationship connectivity, membership class, existe-nce dependency, and generalization and subset hierarchies. Although normalization is not necessarily preserved under the transformation rules, it is feasible to implement a sequence of transformation and normalization operations without loss of information. This approach provides a practical solution to the modeling of real-world problems using first the extended ER model and then its refinement into the relational model.

[1]  Maurizio Lenzerini,et al.  Cardinality Constraints in the Entity-Relationship Model , 1983, ER.

[2]  E. F. Codd,et al.  Recent Investigations in Relational Data Base Systems , 1974, ACM Pacific.

[3]  W. C. McGee,et al.  A Contribution to the Study of Data Equivalence , 1974, IFIP Working Conference Data Base Management.

[4]  William Kent.  Fact-based data analysis and design , 1984, J. Syst. Softw..

[5]  Peter P. Chen,et al.  A Decomposition of Relations Using the Entity-Relationship Approach , 1981, ER.

[6]  Y. Edmund Lien,et al.  On the Equivalence of Database Models , 1982, JACM.

[7]  Maurizio Lenzerini,et al.  INCOD: A System for Conceptual Design of Data and Transactions in the Entity-Relationship Model , 1981, ER.

[8]  Tok Wang Ling.  A Normal Form For Entity-Relationship Diagrams , 1985, ER.

[9]  Randy H. Katz,et al.  Logical Design and Schema Conversion for Relational and DBTG Databases , 1979, ER.

[10]  Laurian M. Chirica,et al.  The entity-relationship model: toward a unified view of data , 1975, SIGF.

[11]  C. J. Date.  A guide to DB2 , 1984 .

[12]  Sushil Jajodia,et al.  Translation of entity-relationship diagrams into relational structures , 1984, J. Syst. Softw..

[13]  Ole Oren.  Integrity Constraints in the Conceptual Schema Language SYSDOC , 1985, ER.

[14]  C. J. Date.  An Introduction to Database Systems, Volume I, 5th Edition , 1986 .

[15]  Peter Scheuermann,et al.  Abstraction Capabilities and Invariant Properties Modelling within the Entity-Relationship Approach , 1979, ER.

[16]  I. T. Hawryszkiewycz,et al.  Database analysis and design , 1984 .

[17]  Elizabeth N. Fong.  Guide on Logical Database Design. , 1985 .

[18]  Hirotaka Sakai.  Entity-Relationship Approach to Logical Database Design , 1983, ER.

[19]  Toby J. Teorey,et al.  Design of Database Structures , 1982 .

[20]  Antonio Di Leva,et al.  Logical Design in Codasyl and Relational Environment , 1983, Methodology and Tools for Data Base Design.

[21]  E. F. Codd,et al.  A relational model of data for large shared data banks , 1970, CACM.

[22]  E. F. Codd,et al.  A Relational Model for Large Shared Data Banks , 1970 .

[23]  Michael L. Brodie,et al.  A Prototyping Approach to Database Applications Development , 1984, IEEE Database Eng. Bull..

[24]  Diane C. P. Smith,et al.  Database abstractions: aggregation and generalization , 1977, TODS.

[25]  Shamkant B. Navathe,et al.  A Methodology for Database Schema Mapping from Extended Entity-Relationship Models into the Hierarchical Model , 1983, International Conference on Conceptual Modeling.

[26]  Ramez Elmasri,et al.  The Category Concept: An Extension to the Entity-Relationship Model , 1985, Data Knowl. Eng..

[27]  David Maier,et al.  The Theory of Relational Databases , 1983 .

[28]  Sushil Jajodia,et al.  On the Representation of Relational Structures by Entity-Relationship Diagrams , 1983, ER.

[29]  T. C. Chiang,et al.  A Data Base Management System with an E-R Conceptual Model , 1979, ER.

[30]  Philip A. Bernstein,et al.  Synthesizing third normal form relations from functional dependencies , 1976, TODS.