This Article 
 Bibliographic References 
 Add to: 
One-to-One Dependencies in Database Design
September 1991 (vol. 3 no. 3)
pp. 371-379

The author focuses on the 1:1 dependency type and shows its significance in database design. Various situations involving 1:1 dependencies are analyzed and classified, and proper treatment of the dependency in those situations is suggested. These dependencies are treated at both the conceptual and the logical design levels. Decision rules are provided for the conversion of 1:1 dependencies into 1:n or n:1 dependencies. These are implemented with the system ADDS for automated database design.

[1] P. P. Chen, "A preliminary framework for entity-relationship models," inEntity-Relationship Approach to Information Modeling and Analysis, P. Chen, Ed. Amsterdam, The Netherlands, North-Holland, 1983, pp. 19-28.
[2] C. J. Date,An Introduction to Database Systems, vols. 1 and 2. Reading, MA: Addison-Wesley, vol. 1, 1981, vol. 2, 1983.
[3] R. Elmasri and S. B. Navathe,Fundamentals of Database Systems. Redwood City, CA: Benjamin/Cummings, 1989.
[4] I.T. Hawryszkiewycz,Database Analysis and Design. Chicago, IL: SRA, 1984.
[5] G. M. Nijssen, "On the gross architecture for the next generation database management systems," inProc. IFIP 77 Conf.B. Gilchrist, Ed. Amsterdam, The Netherlands: North-Holland, 1977, pp. 327-335.
[6] J. Peckham and F. Maryanski, "Semantic data models,"ACM Comput. Surveys. pp. 153-189, Sept. 1988.
[7] P. Shoval, "Essential information structure diagrams and database schema design,"Inform. Syst., vol. 10, no. 4, pp. 417-423, 1985.
[8] P. Shoval and M. Even-Chaime, "ADDS: a system for automatic database schema design based on the binary relationship model,"Data Knowledge Eng., vol. 2, pp. 123-144, 1987.
[9] T. J. Teorey, D. Yang, and J. P. Fry, "A logical design methodology for relational databases using the extended entity-relationship model,"ACM Comput. Surveys, vol. 18, no. 2, pp. 197-222, June 1986.
[10] D. Tsichritzis and F. Lochovsky,Data Models, Prentice Hall, Englewood Cliffs, N.J., 1982.
[11] J. Van Griethuysen, Ed., "Concepts and terminology for the conceptual schema and the information base," ISO Rep. TC97/SC5/WG3-N695, ANSI, NY, Mar. 1982.
[12] G. Verheijen and J. Von Bekkum, "NIAM: An information analysis method," inInformation Systems Design Methodologies: A Comparative Review, Olle, Sol, and Verryn-Stuart, Eds. Amsterdam, The Netherlands: North-Holland, 1982, pp. 537-590.

Index Terms:
database design; 1:1 dependency type; logical design; ADDS; automated database design; data structures; database management systems; software tools
P. Shoval, "One-to-One Dependencies in Database Design," IEEE Transactions on Knowledge and Data Engineering, vol. 3, no. 3, pp. 371-379, Sept. 1991, doi:10.1109/69.91053
Usage of this product signifies your acceptance of the Terms of Use.