Standard transformations for the normalization of ER schemata

Information Systems

Volumn 21, Issue 2, 1996, Pages 187-208

  Rauh, Otto ^a   Stickel, Eberhard ^b  

^a HEILBRONN UNIVERSITY   (Germany)

^b EUROPEAN UNIVERSITY VIADRINA   (Germany)

Author keywords

Entity Relationship Modeling; Normalization; Standard Transformations

Indexed keywords

ALGORITHMS; COMPUTER SIMULATION; DATA STRUCTURES; MANAGEMENT INFORMATION SYSTEMS; SYSTEMS ANALYSIS;

ENTITY RELATIONSHIP MODELING; NORMALIZATION; STANDARD TRANSFORMATIONS;

RELATIONAL DATABASE SYSTEMS;

EID: 0030124882     PISSN: 03064379     EISSN: None     Source Type: Journal    
DOI: 10.1016/0306-4379(96)00011-7     Document Type: Article

References (22)

1. P. Atzeni, V. De Antonellis. Relational Database Theory. Redwood City, California: Benjamin/Cummings (1993).
2. C. Batini, S. Ceri, S. Navathe. Conceptual Database Design: An Entity-Relationship Approach. Redwood City, California: Benjamin/Cummings (1992).
3. P. Chen. The entity-relationship model: toward a unified view of data. ACM Transactions on Database Systems, 1(1): 9-36 (1976).
4. I. Chung, F. Nakamura, P. Chen. A decomposition of relations using the entity-relationship approach. Proc. of the 2nd International Conference on Entity-Relationship Approach, pp. 149-172, Washington, D.C. 1981, North-Holland (1983).
5. E. Codd. Relational completeness of data base sublanguages. In: R. Rustin (ed.), Data Base Systems, Englewood Cliffs, New Jersey: Prentice-Hall (1972).
6. G. Gardarin, P. Valduriez. Relational Databases and Knowledge Bases, Reading, Mass.: Addison-Wesley (1989).
7. J.-L. Hainaut. Entity-relationship models: formal specification and comparison. In H. Kangassalo (ed.), Proceedings of the 9th International Conference on the Entity-Relationship Approach, pp. 53-63, Lausanne, Switzerland (1990).
8. J.-L. Hainaut, C. Tonneau, M. Joris, M. Chandelon. Schema transformation techniques for database reverse engineering. In: Proceedings of the 12th International Conference on Entity-Relationship Approach, pp. 353-372, Arlington, Texas, Dec 15-17 (1993).
9. P. Jaeschke, W. Stucky. From Conceptual to Logical Database Design. Forschungsbericht Nr. 282, Universität Karlsruhe (1993).
10. S. Jajodia, P.A. Ng. The problem of equivalence for entity-relationship diagrams. IEEE Transactions on Software Engineering, 9(5): 617-630 (1983).
11. I. Kobayashi. Losslessness and semantic correctness of database schema transformations: another look of schema equivalence. Information Systems, 11(1): 41-59 (1986).
12. T.W. Ling. A normal form for entity-relationship diagrams. Proc. of the 4th International Conference an Entity-Relationship Approach, pp. 24-35, Chicago, North-Holland (1985).
13. T.W. Ling. An analysis of multivalued and join dependencies based on the entity-relationship approach. Data & Knowledge Engineering, Vol. 1, pp. 253-271 (1985).
14. D. Maier. The Theory of Relational Databases, Rockville, Md: Computer Science Press (1983).
15. J. Makowsky, V. Markowitz, N. Rotics. Entity Relationship Consistency for Relational Schemas. In G. Ausiello and P. Atzeni (eds.), ICDT '86, Springer-Verlag (1986).
16. ded - eine Erweiterung des Entity-Relationship-Modells zur Modellierung deduktiver Informationssysteme. Informatik Forschung & Entwicklung, Vol. 10: 128-138 (1995).
17. O. Rauh, E. Stickel. Searching for Compositions in ER Schemes. In R. Elmasri, V. Kouramajian (eds.), Proceedings of the 12th Int' Conference on Entity-Relationship Approach, pp. 75-86, Arlington, TX (1993)
18. ded. In P. De, C. Woo (eds.), Proceedings of the Fourth Annual Workshop on Information Technologies & Systems (WITS '94), pp. 195-204, Vancouver, Canada (1994).
19. O. Rauh, E. Stickel. Standard transformation for the normalization of ER schemata. In J. Iivari, K. Lyytinen, M. Rossi (eds.), Advanced Information Systems Engineering, pp. 311-326, 7th International Conference, CAiSE '95, Jyväskylä, Finland, June 12-16 (1995).
20. A. Rosenthal, D. Reiner. Theoretically sound transformations for practical database design. Proc. of the 6th International Conference on Entity-Relationship Approach, New York 1987, pp. 115-132, North-Holland (1988).
21. J. Ullman. Principles of Database and Knowledge-Base Systems, Volume I, Rockville, Maryland: Computer Science Press (1988).
22. G. Verheijen, J Van Bekkum. NIAM: an information analysis method. In T. Olle, H. Sol, A. Verrijn-Stuart (eds.), Information Systems Design Methodologies: A Comparative Review, North-Holland (1982).