A translation of the one-to-one relationship for introductory relational database courses

Authors:
Jonathan P. Bernick
Affiliations:
Coastal Carolina University, Conway, South Carolina
Venue:
ACM SIGCSE Bulletin
Year:
2003

Citing 10
Cited 0

Relational database writings (1985–1989)

Relational database writings (1985–1989)
Database management (3rd ed.)

Database management (3rd ed.)
Database systems: principles, programming, performance

Database systems: principles, programming, performance
Relational Database Design Clearly Explained

Relational Database Design Clearly Explained
Database Application Development and Design

Database Application Development and Design
Database Management Systems: Designing and Building Business Applications

Database Management Systems: Designing and Building Business Applications
Database System Concepts

Database System Concepts
Fundamentals of Database Systems

Fundamentals of Database Systems
Schaum's Outline of Fundamentals of Relational Databases

Schaum's Outline of Fundamentals of Relational Databases
Introduction to Database Systems

Introduction to Database Systems

Quantified Score

Hi-index	0.00

Visualization

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.