Abstract
The translation of the one-to-one relationship from the Entity/Relationship model to the relational model while preserving one-to-one correspondence between the members of the participating entity sets is a topic that has been neglected in introductory database textbooks. In this paper, we provide a simple method, intended for students taking a first course in relational database design, that accomplishes this without introducing nulls or violating the relational model.
- Date, C. J., "A Note on One-to-One Relationships," in Relational Database Writings 1985--1990, Addison-Wesley, 1990. Google ScholarDigital Library
- Date, C. J., An Introduction to Database Systems, Seventh Edition, Addison Wesley Longman, Inc., 2002. Google ScholarDigital Library
- Elmasri, R., and Navathe, S., Fundamentals of Database Systems, Third Edition, Addison-Wesley Publishing, 2000. Google ScholarDigital Library
- Harrington, J., Relational Database Design Clearly Explained, Morgan Kaufman, 1998. Google ScholarDigital Library
- Mannino, M., Database Application Development and Design, McGraw-Hill Higher Education, 2001. Google ScholarDigital Library
- Mata-Toledo, R., and Cushman, P., Schaum's Outline of Fundamentals of Relational Databases, The McGraw-Hill Companies, Inc., 2000. Google ScholarDigital Library
- McFadden, F., and Hoffer, J., Database Management, Third Edition, The Benjamin/Cummings Publishing Company, Inc., 1991. Google ScholarDigital Library
- O'Neil, P., Database: Principles, Programming, Performance, Morgan Kaufman Publishers, Inc., 1994. Google ScholarDigital Library
- Post, G., Database Management Systems: Designing and Building Business Applications, McGraw-Hill Higher Education, 2002. Google ScholarDigital Library
- Silberschatz, A., Korth, H., and Sudarshan, S., Database System Concepts, Fourth Edition, McGraw-Hill Higher Education, 2002. Google ScholarDigital Library
Index Terms
- A translation of the one-to-one relationship for introductory relational database courses
Recommendations
A Method for Rough Relational Database Transformed into Relational Database
SSME '09: Proceedings of the 2009 IITA International Conference on Services Science, Management and EngineeringIt is decomposed the data of rough relational database and transformed into relational database according to the characteristic of rough relational database and relational database and in virtue of multiplication principle and Descartes of basic ...
Comments