Title
A practical approach to transforming extended ER diagrams into the relational model
Abstract
Constructs for the extended ER 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, existence 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.
Year
DOI
Venue
1987
10.1016/0020-0255(87)90022-3
Inf. Sci.
Keywords
Field
DocType
practical approach,extended er diagram,relational model,computer science,humanities,social sciences,engineering
Information system,Relational calculus,Normalization (statistics),Relational database,Artificial intelligence,Hierarchy,Relational model,Mathematics,Entity–relationship model
Journal
Volume
Issue
ISSN
42
2
0020-0255
Citations 
PageRank 
References 
0
0.34
17
Authors
3
Name
Order
Citations
PageRank
YANG Dong-Qing1975201.51
Toby J. Teorey2914710.11
James P. Fry3702481.74