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-Qing | 1 | 975 | 201.51 |
Toby J. Teorey | 2 | 914 | 710.11 |
James P. Fry | 3 | 702 | 481.74 |